Check Box data property changes when copied.

asked 2019-01-17 17:17:56 +0100

Steve1948 gravatar image

I place a check box on Sheet1 and go to design mode properties under data and link it to cell A100. Sheet1 is copied to Sheet2. On Sheet2 the check box data property reads Sheet1.A100. Is there anyway to copy Sheet1 so the check box on Sheet2 remains A100, without reference to Sheet1? Thanks

edit retag flag offensive close merge delete