Sheetal, the buttons have to be from the forms toolbar, view, toolbars forms
to right click and assign the macros, sounds like you have a button from the
control toolbar

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Sheetal" wrote in 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/