View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default Removing/restoring menubar in a macro

One way:

Application.CommandBars("Standard").Visible = False
Application.CommandBars("Standard").Visible = True

In article ,
"Bob Moister" wrote:

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