Checkbox doesn't work in protected mode

I have an excel sheet in which the majority of it is protected and cells are left open to be filled in by my employees while they cannot manipulate all of them. This is my first time venturing into Macros/VBA, etc. so any help will be appreciated.

I created a checkbox that when clicked, hides multiple rows as well as successfully hides other checkboxes. The code is probably longer than it needs to be and is very simple but I don't know another way to do it at this point. Basically, I want to protect my sheet and the checkbox still work. Can anyone help?

Also, I have the sheet actually named "Employee Information" and I don't know how else to do it except to say "activesheet" though my guess is that my protecting the sheet it no longer recognizes it as an active sheet.

Please help, on a time crunch! I am using Excel2010. Also worth mentioning - when I emailed this to my boss (saved as macro-enabled worksheet), he opened it, enabled the macros and it did not work for him (sheet was unprotected at the time). Any ideas?

Please Login or Register  to view this content.

Welcome to the forum. Please use code tags to frame your code. To do this click 'Edit Post' under your original post, highlight all the code, and press the # button in the tool bar.

Try this:

Please Login or Register  to view this content.

Also you'll have to make sure that the checkbox has its protected property turned off. You can do this by right clicking the checkbox and going to properties.

Please see post #2 to amend your original post before we proceed.

Original post amended