Command Button- Assign Macro & Sheet Protection problem

[Yunus]

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

 

[Guest]

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


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