unprotect hidden sheet

[dawall33]

I am using a hidden sheet to track several counters that are accessed by code
off of different sheets. I have protected that entire sheet .

I want to be able to unprotect the sheet to update the counters without
unhiding it first.

 

[Dave Peterson]

with worksheets("hiddensheetnamehere")
.unprotect password:="hi"
.range("A1").value = "whatever update you need"
.protect password:="hi"
end with

 

[Gord Dibben]

No need to protect that hidden sheet.

Just make sure the workbook is protected so's users cannot unhide the sheet.

Or make the sheet xlveryhidden


Gord Dibben MS Excel MVP