Command Button Excel 2007

[dhstein]

I have a "regular" command button which was originally created in Excel 2000.
I can copy this button to a new Excel 2007 document. When I do that, I can
right click on the button and I get the option to "Assign Macro". This works
very well. In Excel 2007, it seems that the only command button I can add is
an Active X control and this does not give me the right click behavior that I
have with the other button. Is there a way in 2007 to add a command button
which gives me the right click "Assign Macro" option? Thanks for any help on
this.

 

[Gord Dibben]

Developer>Insert.............you get two options.

Forms Controls or Activex Controls.

Add a button from the Forms controls, not the Activex controls.


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

I want to add this to Gord's reply

If you not see the Developer tab (not on by default) do this
To display the Developer tab go to Office Button >Excel Options...Popular
and check "show developer tab............................"

Gord : Do you like 2007 ????? after using it for a few weeks now

 

[dhstein]

Gord, Ron,

Thanks for your help.

I want to add this to Gord's reply

If you not see the Developer tab (not on by default) do this
To display the Developer tab go to Office Button >Excel Options...Popular
and check "show developer tab............................"

Gord : Do you like 2007 ????? after using it for a few weeks now

 

[Gord Dibben]

Not working with it much yet but don't mind the Ribbon and other new
features that many find difficult or downright repugnant.

Not nearly as bad as I thought, considering the amount of negative input I
have seen since it was introduced.

But note the "not working with it much yet"<g>


Gord