View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
WhytheQ WhytheQ is offline
external usenet poster
 
Posts: 246
Default COMMANDBAR MANIPULATION....

Here's a little teaser. I want a button to go straight to a small
submenu.

If I go EDITGO TO...SPECIAL... a small menu appears (the one with
'blanks':'current array'etc)
How can I get a hook on this menu?

I suspect it'll be something like:
Application.CommandBars("??").Visible = True

or maybe something like:
myCustomMenu.Controls.Add(msoControlButton, 226)


Any help greatly appreciated,
Jason.