Macro to display a menu item - possible?
 

Is it possible to write a macro thatll display an excel built in inputbox, eg
data|getExternalData|newDatabaseQuery


Thanks

Tony

Macro to display a menu item - possible?
 

you can create a private tool bar.
also you can write the menu on an excel sheet and make links on ever
line

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Macro to display a menu item - possible?
 

In VB Editor use View/Objeect Browser and do a search for xldialog.

You get a huge list. Doesn't look like the one you want is there thoug
(of course <grin)

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Macro to display a menu item - possible?
 

Thanks...
That opens some more doors!

Tony