Protecting Cells with macros
Hi Peter,
One way is to amend your macros to initially unprotect the sheet and finally
reprotect the sheet.
An alternative approach would be to set Protect's UserInterfaceOnly argument
to True. This setting is not persistent and so needs to be reset each time
the workbook is opened.
---
Regards,
Norman
"Peter McCaul" wrote in message
...
I would like to protect 4 cells in my document so changes cannot be made
to
them. The rest of the cells I would like to leave unprotected. I took
the
lock off the rest of the cells and I protected my worksheet. It worked
fine
but the only problem is I can't run my macros. Is there a way I can run my
macros and protect my cells. Any help is appreciated. Thanks.
|