Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button- Assign Macro & Sheet Protection problem
I have created inserted a Button and assinged a Macro to it. I have tried Form Control Command Button and Active ControlX Command Button but encounetring thr following problems... 2 questions... The Buttons do not work when the sheet is protected. How can I overcome this The Form Control Button does not allow me to Colour the Button, so I assume I have to replace it with a Active Control X Command Button, but how do I assign a Macro to this. I dont get the option when I right click. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Command Button- Assign Macro & Sheet Protection problem
hi,
can't see why they would not work in protected sheet connect code via developper tab activate the design mode right click the button and choose assign macro - edit macro /view code put your code between sub and end sub - don't forget to deactivate teh design mode when testing greetz "Yunus" schreef in bericht m... I have created inserted a Button and assinged a Macro to it. I have tried Form Control Command Button and Active ControlX Command Button but encounetring thr following problems... 2 questions... The Buttons do not work when the sheet is protected. How can I overcome this The Form Control Button does not allow me to Colour the Button, so I assume I have to replace it with a Active Control X Command Button, but how do I assign a Macro to this. I dont get the option when I right click. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign MAcro to command button | Excel Programming | |||
Assign Macro to Command Button | Excel Programming | |||
Assign a macro to a command button | Excel Programming | |||
command button and assign macro | Excel Programming | |||
Assign Macro to Command Button | Excel Programming |