Assign macro to button on a multi-page tab

 Nuwan -
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?


2 replies

This may helpful to you!!

Nayana Adassuriya
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