Change values on a protected worksheet?

[craigyg]

I have been running into errors in my code when I try to update or change values on a protected worksheet via the VBA code. Rather than go through my code and first unprotect it, then reprotect after the code executes - i was wondering if there was a better way to go about this. Any ideas?

 

[HalfAce]

Yes, you can select all the cells you want to be able to change while protected
and from the menu choose Format > Cells > Protection tab and make sure the
'Locked' checkbox is unticked.

[Edit:]
Is there a reason you don't like unprotecting / reprotecting within the code?

 

[craigyg]

Additional related question...

In addition, does anyone know if there is a way to write a class module or something that performs as follows: anytime there is a change to a value on a protected sheet from the code to unprotect the sheet (and reprotect after code execution)? I would love to do it in a class module so I wouldn't have to add my unprotect, protect code to every subroutine that changes a value on a protected sheet.

 

[craigyg]

Protection

Half Ace -

In response to your question - I just thought that constantly protecting and unprotecting the sheets might slow down my code.

Also, your response led me to another question: What if I want to update values on a protected sheet to locked cells? There are definitely times I want the code to change some value in a cell and I don't want the user to be able to change that value themselves by going into the worksheet.