View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default How to create pop menu in macro ?

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

"broogle" wrote in message
ups.com...
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