Hi,
I find all references for hiding all toolbars during full screen only.
But i need to hide all toolbars and menu bars even after restoring the excel.
Hi,
I find all references for hiding all toolbars during full screen only.
But i need to hide all toolbars and menu bars even after restoring the excel.
Ravikumar,
* Please Add Reputation if solved.
Thanks friends i find the solution.
![]()
Private Sub Workbook_Activate() Application.ScreenUpdating = False Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" Application.DisplayFormulaBar = False Application.DisplayStatusBar = Not Application.DisplayStatusBar ActiveWindow.DisplayWorkbookTabs = False Application.ScreenUpdating = True End Sub Private Sub Workbook_Deactivate() Application.ScreenUpdating = False Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)" Application.DisplayFormulaBar = True Application.DisplayStatusBar = True Application.ScreenUpdating = True End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks