Addin Menu Question

E

ExcelMonkey

There are certain menu items which are greyed out in Excel
when there aren't any workbooks open (ie. Save, Save As
etc). I want to grey out my menu items in the menu that
is generated by my Add-in. I am assuming I have to run a
routine that checks to see if a file is open and then make
the menu accessible or not. Does anyone knoe how to do
this?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Addin Menu when file not open 1
addin menu button xl2007 2
Question on using Ron de Bruin's Excel menu sample code 4
macros in my custom xla Addin - how to make visible in Macro menu? 2
How do I have multiple workbooks open and have a menu to switch be 2
Remove an obsolete worksheet from an addin. 2
Determining what menu item called a macro 6
How to display a macro generated menu in Excel 2007 2

Top