I was searching a bit on how to show/hide native features of excel and found the below settings. What is a better place to store these settings? Is it Workbook_Activate or Workbook_Open and what is the difference?
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
.DisplayFullScreen = True
.WindowState = xlMaximized
.StatusBar = "My custom message"
End With
With Application
.DisplayFullScreen = False
.DisplayAlerts = True
.EnableEvents = True
.ScreenUpdating = True
End With
Moreover, I need answers to the below questions as I have got different answers on different websites.
1. How to disable StatusBar? Is .StatusBar = False a correct syntax?
2. Is it necessary to switch off the .WindowState?
3. is setting .ScreenUpdating to false while workbook open and set to true before close a good idea? or do i need to keep on setting false/true everytime i call a sub/function?
4. is DisplayFullScreen = True same as putting the menubar and ribbon off or is there a different command?
5. How to hide row number 1 2 3 4 and column letters a b c d through vba code
6. How to hide worksheet tabs (where sheet names are shown)?
7. How to hide vertical and horizontal scrollbars
8. Have I missed out any setting to turn on/off? - I need a complete blank screen when the workbook is opened. I want to show my own interface to user without excel native functions.
Thank you
Bookmarks