How to unlock locked cells by MACRO?!

  • Thread starter Thread starter =?ISO-8859-2?Q?Petr_N=ECme=E8ek?=
  • Start date Start date
?

=?ISO-8859-2?Q?Petr_N=ECme=E8ek?=

I have locked Sheet and I need to change particular cells. But when my
macro wants to change it => ERROR :/
Is there any way to unprotect these particulary cells by macro and
change them? - after that action, of course, I want to lock them again.
Please help me, Pedro
 
Just unprotect the sheet, do the work, and reprotect the sheet. Kind of like:

activesheet.unprotect password:="yourpassword"
'your code to change stuff
activesheet.protect password:="yourpassword"
 
Dave Peterson napsal(a):
Just unprotect the sheet, do the work, and reprotect the sheet. Kind of like:

activesheet.unprotect password:="yourpassword"
'your code to change stuff
activesheet.protect password:="yourpassword"
Click to expand...
Thanks!!! :)
 
Back
Top