As said before, you only get this message with a button
from the Forms toolbar. However, you should be able to
manually assign a macro to a button from the Control
Toolbox toolbar.
1)Go into design mode by clicking the icon with the set
square and pencil on it, on the Control Toolbox toolbar.
2)Right click on the button and click View Code
3)In the following sub type Call followed by the name of
the macro you wish to assign.

libby
-----Original Message-----

hello!

I have just created a button in my excel spreadsheet, and
want to
assign a macro to it. I have followed the help in the
Excel help menu
which suggested that i right click the button and select
assign macro.

However, when i rightclick the button i created, i don't
get this
option. i have tried clicking all parts of the button,
ie the button
itself, and also the selection boxes.

Does anyone know of any easier ways of creating buttons
and then
assigning macros to them, or let me know what i am doing
wrong.

Thanks


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.