2010 Excel Checkbox Issue

**tommyfernandez** · 03-12-2013, 11:34 AM

Greetings,

I have created a 2010 Excel spreadsheet that contains multiple check boxes and other cells whose calculated result are dependent on these check boxes. The spreadsheet is password protected. For some reason, the check boxes are not functioning; That is, I can't even click on them. Any advice or direction on how to resolve this would be greatly appreciated! The workbook containing the spreadsheet is available for users online. Might this have some bearing on the matter??

-Tommy

**Dunc3142** · 03-12-2013, 12:19 PM

The cell that the check box is linked to has to be unlocked or Excel can not change that cell so it will not except the check.
Unlocking cells is under the Home Tab and Cells group under format.

**tommyfernandez** · 03-12-2013, 01:05 PM

Thanks for the prompt response. I have added a new check box, not linked to anything, and it won't (cannot click). I unprotected the source to the existing check boxes but they still do not allow me to click on them as well.. I even changed the workbook out of Compatibility Mode to no avail.. What could it be??

-Tommy

**Dunc3142** · 03-12-2013, 07:08 PM

I don't know, it works for me. Could you send a copy and I will try to see what the problem is.

**tommyfernandez** · 03-12-2013, 07:34 PM

I figured it out! The problem was that the workbook had macros that had to be enabled for the check boxes to work.
Thanks for the assistance (and patience) throughout this process.
-Tommy