How to create pop menu in macro ?

[broogle]

Hi VB Guru! Is it possible to create a pop up menu in macro?, Let say I
have 8 macros in 1 spreadsheet, I use these macro quite often, how can
I put all these macros in one pop up box and I can select it whenever I
want, rather than keep pressing Alt-8 or make the short cut. Please
help. It would be great if the pop menu is always on top. Thanks

 

[Robin Hammond]

You could build yourself a custom userform with a bunch of command buttons
on it and display it modelessly if you are in XL2000 or above, but...

Why not just build a toolbar. That's what they are for. John Walkenbach has
some code to build one on the fly on his site www.j-walk.com. Or, if this is
just for your use, just build a custom toolbar and attach it to your sheet.

Robin Hammond
www.enhanceddatasystems.com