Removing/restoring menubar in a macro
 

Application.CommandBars("Worksheet Menu Bar").Enabled = False

Application.CommandBars("Worksheet Menu Bar").Enabled = True

--
Regards,
Tom Ogilvy

"Bob Moister" wrote in message
...
I can manually hide the menu bar, and I can manually
reset it so it again is visible, but I can't get the
macro recorder to produce the code.
Will someone please tell me the appropriate code to use
so that I can manually insert it into a macro.
Thanks in advance,
Bob