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