unprotect hidden sheet

D

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.
 
D

Dave Peterson

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

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
 
Top