View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default COMMANDBAR MANIPULATION....

Hi Jason,

Try:

Application.Dialogs(xlDialogSelectSpecial).Show


---
Regards,
Norman


"WhytheQ" wrote in message
oups.com...
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.