Thanks for the hint..

The site
http://www.ozgrid.com/News/ExcelCust...oRunMacros.htm

indicates that even in the old Excel97 that I use, there are the event
indicators

Workbook_Open, Workbook_BeforeClose, and possibly others

I need to explore to see if these functions are implemented in my
version of Excel
Worksheet_Open
Worksheet_BeforeClose

I have also found using Google a page that talks about using the
Worksheet open / before close event indicators to hide menus.


George Nicholson wrote:
There is a Workbook_Deactivate event where you might be able to
deactivate/disable your custom menu. Then use Workbook_Activate event to
re-activate/enable your custom menu.

The idea being your menu wouldn't be available unless a specific workbook is
active.

I've never tried this, so I don't know for sure whether it is as simple as
that. Sure sounds good in theory though, eh? :-)

HTH,