Assign macro to button on a multi-page tab [Closed]

- - Latest reply:  Nuwan - May 24, 2010 at 08:00 AM
Hello,
This seems easy but I am really stuck. I need to have a floating set of commands in a spreadsheet and I can't use attached custom toolbars (IT policy). I created a userform with a multi-page tab area, each tab has a number of buttons on it. I want to assign a macro to each of the buttons but I can't figure out how. I already created the macros. Can anyone help me?

thanks
Shelly
See more 

2 replies

0
Thank you
http://www.ozgrid.com/Excel/assign-macros.htm

This may helpful to you!!


thanks
Nayana Adassuriya
0
Thank you
Hi Nayana,

Use the develpoer menu insert control option to draw a buton & this has to be done using the Form control category, This will automaticaly pop up a window asking to link the macro you have already Created or else right click on the button on non design mood to assign the macro