I have a shared workbook with several columns of checkboxes. Checkmarks are placed in the appropriate boxes by various users and the file is saved, but upon reopening the file, some of the checkmarks are missing. I'm a new user of Excel 2007....any ideas on what steps to take to make sure all checkmarks are saved? Thanks.
Checkboxes in Excel 2007
- Thread starter freidag
- Start date
Freidag
This may help
1. Right click a Check Box and goto Format Control
1 a. If you've got lots of Check Boxes, Right Click on one and then Ctrl Shift Click the second, 3rd, 4th etc until you have them all grouped, then goto Format Control
2. On the Protection Tab, Enable Locked
3. On the Properties Tab, Select Don't Move or Size with Cells
4. Close the Format Control dialogue with OK
5. If you have lots of Check Boxes still selected I would Right Click them and Group them. This still allows you to select them individually, but at least they should stay together.
6. Goto Tools, Protection, Protect Sheet and enable protection, go down to the bottom and ensure that Edit Objects is Not Selected
Hope that helps
This may help
1. Right click a Check Box and goto Format Control
1 a. If you've got lots of Check Boxes, Right Click on one and then Ctrl Shift Click the second, 3rd, 4th etc until you have them all grouped, then goto Format Control
2. On the Protection Tab, Enable Locked
3. On the Properties Tab, Select Don't Move or Size with Cells
4. Close the Format Control dialogue with OK
5. If you have lots of Check Boxes still selected I would Right Click them and Group them. This still allows you to select them individually, but at least they should stay together.
6. Goto Tools, Protection, Protect Sheet and enable protection, go down to the bottom and ensure that Edit Objects is Not Selected
Hope that helps