ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hiding the Menu bar (https://www.excelbanter.com/excel-programming/316388-hiding-menu-bar.html)

kcammandc[_2_]

hiding the Menu bar
 

hi

sorry about this string, my mind just went blank, the code needed t
be:

ActiveWindow.DisplayWorkbookTabs = False
Application.DisplayScrollBars = False
Application.DisplayFormulaBar = False
Application.CommandBars("standard").Visible = False
Application.CommandBars("formatting").Visible = False
Application.CommandBars("Worksheet Menu Bar").Enabled = False

thanks anyway

Eliot
IT traine

--
kcammand
-----------------------------------------------------------------------
kcammandc's Profile: http://www.excelforum.com/member.php...fo&userid=1633
View this thread: http://www.excelforum.com/showthread.php?threadid=27720



All times are GMT +1. The time now is 07:48 PM.

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