Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make macros execute on a protected sheet?
I have several command buttons attached to macros to enlarge or reduce the
size of embedded charts. When I protect the sheet, the macros will not execute. Is there a way to protect the sheet and still enable the macros? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make macros execute on a protected sheet?
In your macro you could just add a line of code at the begining to
unprotect the sheet and then at the end of the code you can protect the sheet again. activesheet.unprotect - macro code activesheet.protect if you have the sheet passwork protected you will need to add the password at the end activesheet.unprotect "password" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I make macros execute on a protected sheet?
ActiveSheet.Unprotect Password:="XXX"
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run macros on protected sheet | Excel Discussion (Misc queries) | |||
protecting macros for a protected sheet | Excel Discussion (Misc queries) | |||
Enabling macros while the sheet being protected ! | Excel Discussion (Misc queries) | |||
is it possible to use macros when the sheet is protected | Excel Discussion (Misc queries) | |||
run macros on a protected sheet? | Excel Programming |