Protect Sheet Workaround for Allowing Hide/Unhide

I have the following macro code on a "selector" sheet where the user can select sheets to appear when the check box is checked. I also want to protect the structure of my workbook so that tabs cannot be renamed, etc. Protect workbook disables the unhide and the tabs no longer appear when the boxes are checked. Is there a way to protect the workbook and still allow the checkboxes to work as I planned? (protecting sheets does not protect the structure of the workbook).

Please Login or Register  to view this content.

Thank you,
Sara

You must Unprotect and Protect workbook:

Please Login or Register  to view this content.

Artik

Thank you very much for the helpful and speedy reply. So far this is working...just 56 more entries to change.

Since you have to tinker with it, I suggest you change it this way.
1. One parameterized routine that will take care of hiding/unhiding the sheet:

Please Login or Register  to view this content.

2. The CheckBoxNN_Click routines would look like this:

Please Login or Register  to view this content.

But you've probably already finished. Finally, improving 56 procedures is not that much.

Artik