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

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