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.
|