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.

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



dawall33 wrote:

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

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

On Wed, 22 Apr 2009 13:15:02 -0700, dawall33
wrote:

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.