ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Removing/restoring menubar in a macro (https://www.excelbanter.com/excel-programming/278614-re-removing-restoring-menubar-macro.html)

J.E. McGimpsey

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



All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com