toolbar button for Vba code!

[Legacy 169354]

Hi,

I have made a vba code/userform, and I would like to activate it after i close it by having a toolbar button. How do I define a macro that excel can see and then assign a button to it!??

Thanks!

 

[xenou]

it's not possible to say without knowing if you are using Excel 2003 or Excel 2007/2010. Toolbars changed dramatically between these versions. This is pretty common so I'd suggest you google something like Excel assign macro toolbar button

ξ

 

[Legacy 169354]

Excel 2003

 

[xenou]

It's hard to describe but if you figure out how to customize your toolbar, you can also see that you can add a custom toolbar button to the menu from the choice of menus to customize. You just drag it up to (any) toolbar in any location. Once you've added this toolbar button, leave the edit toolbar dialog open and right click on it - there are many options such as changing the image, and (of course) assigning a macro. Then you are good to go.

Figure out how to just add or remove a toolbar button. From there, its a short step to a custom button.

Google is (still) your friend - I can't but believe there are many examples. Probably even YouTube videos now.