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.

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.

COMMANDBAR MANIPULATION....
 

as per usual: spot on advice Norman!
Jason




Norman Jones wrote:
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.