![]() |
Hide menu bar
Hi! I cant hide the menu bar from a workbook. I've tried this macro; the
others bars are hidden but the menu bar didnt. Someone could tell me what I am doing wrong?? Another question: the windows live bar is appearin too even if I deselect it. How can I desable it? It can be done with the macro too??? Macro: Private Sub Workbook_Open() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.DisplayExcel4Menus = False Application.DisplayFormulaBar = False Application.DisplayInsertOptions = False Application.DisplayPasteOptions = False Application.DisplayScrollBars = False Application.DisplayStatusBar = False Application.DisplayFullScreen = True Sheets("Menu").Select Range("A8").Select End Sub |
Hide menu bar
Application.Commandbars(1).Enabled = False
-- __________________________________ HTH Bob "Dani Lima" wrote in message ... Hi! I cant hide the menu bar from a workbook. I've tried this macro; the others bars are hidden but the menu bar didnt. Someone could tell me what I am doing wrong?? Another question: the windows live bar is appearin too even if I deselect it. How can I desable it? It can be done with the macro too??? Macro: Private Sub Workbook_Open() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.DisplayExcel4Menus = False Application.DisplayFormulaBar = False Application.DisplayInsertOptions = False Application.DisplayPasteOptions = False Application.DisplayScrollBars = False Application.DisplayStatusBar = False Application.DisplayFullScreen = True Sheets("Menu").Select Range("A8").Select End Sub |
All times are GMT +1. The time now is 01:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com