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
