I do not have the option to assign a macro when I right click a control
button that I have placed on a spreadsheet from the control toolbar.
However, when I insert an autoshape, I do have the option when I right click
to assign a macro. This causes an error in that the file path cannot be
found, even though the macro works when accessed the usual way.

Can anyone help me please??

Hi ewan72

Press the first button on the control toolbox toolbar to go into the design
mode
Double click on the button you placed on your worksheet.
The VBA editor will open with this

Private Sub CommandButton1_Click()

End Sub

You can place the code in the event or place the macroname in the event.
Press Alt-q to go back to Excel and press the first button on the
control toolbox again to exit the design mode

If you use Excel 97 Change the takefocusonclick property to false in the properties of the button



--
Regards Ron de Bruin
http://www.rondebruin.nl


"ewan72" wrote in message ...
I do not have the option to assign a macro when I right click a control
button that I have placed on a spreadsheet from the control toolbar.
However, when I insert an autoshape, I do have the option when I right click
to assign a macro. This causes an error in that the file path cannot be
found, even though the macro works when accessed the usual way.

Can anyone help me please??