Put it in the Workbook_Activate and Workbook_Deactivate events instead of
Workbook_Open and Workbook_BeforeClose.

And Unhide your menu after all the rest were hidden.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"anon" wrote in message
ups.com...
Thanks.

However this still creates a problem - users are likely to have more
than this one excel file open at once - and if they do then there are
no menu bars on their other files either. Is there a way round this?

Also this hides a customer menu bar - can I leave this visible? Is
there a way for a custom meu bar only to be visible in one excel file
(ie this one) and not in any others?