Protecting Cells with macros

[Peter McCaul]

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.

 

[Norman Jones]

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.

 

[Tom Ogilvy]

have you code unprotect the worksheet, run, reprotect the worksheet

Use the UserInterfaceOnly argument set to true in a protect statement.

See help for the protect method for details.