Addin Menu Question
 

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

Addin Menu Question
 

Hi

Access the application events, they run when "any file"s are opened, closed,
activated, ... See
http://www.cpearson.com/excel/AppEvent.htm
on this.

HTH. Best wishes Harald

"ExcelMonkey" skrev i melding
...
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