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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Change values on a protected worksheet?
- Thread starter craigyg
- Start date
HalfAce
MrExcel MVP
- Joined
- Apr 6, 2003
- Messages
- 9,456
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?
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?
Upvote
0
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.
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.
Upvote
0
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.
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.
Upvote
0
