DeveloperInsert.............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


On Sat, 14 Feb 2009 08:13:02 -0800, dhstein
wrote:

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.