Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Cells with macros
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting Cells with macros
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. -- Regards, Tom Ogilvy "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting a worksheet / workbook with macros | Excel Discussion (Misc queries) | |||
Protecting My Macros | Excel Worksheet Functions | |||
Protecting Macros | Excel Programming | |||
Protecting Macros -is it possible | Excel Programming | |||
protecting cells with macros | Excel Programming |