This file might be a help:
http://www.bygsoftware.com/examples/...tiveWbDemo.zip

It's in the "Menu Routines" section on page:
http://www.bygsoftware.com/examples/examples.htm

It contains VBA code that will activate a menu only when the workbook it is
in is active.
The code is open and commented.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"Roger Bedford" wrote in message
...
I have an Excel 5 file where the macros automatically turn a floating
toolbar
off if another sheet in that file is selected or if the file is closed.
However it does not turn off the floating toolbar if I change to another
open
file. How do I solve this and would there be a change to the solution if
I
were using Excel 2002? Any suggestions would be much appreciated.

Roger