Protected Worksheet Error when Rows/Objects are hidden

[learn2vba]

Scenario:

Worsheet is protected. Only Forms and Activex Controls can be accessed.

There hidden rows and objects that will be unhidden/enabled when certain options are selected.

The script runs perfectly when worksheet is unprotected but gives errors when protected.



Please help

 

[Joe4]

The script runs perfectly when worksheet is unprotected but gives errors when protected.

You need to add to your VBA to unprotect the sheet before you try doing anything to it, and then have it re-protect at the end.
So the steps of your VBA code are:
1. Unprotect sheet
2. Perform steps
3. Protect sheet

See here for how to add that code: Protect and UnProtect Worksheets in Excel VBA - ANALYSISTABS - Innovating Awesome Tools for Data Analysis!
Note you do not need a separate procedure to do these steps. You can simply add the lines of code at the top and bottom of your existing code.

 

[learn2vba]

Thanks Joe! This really helped!

 

[Joe4]

You are welcome.