View Tab


Show

alt text
Application.ShowStartupDialog = True 
Application.DisplayFormulaBar = True
Application.DisplayStatusBar = True
Application.ShowWindowsInTaskbar = True

Comments

alt text
Application.DisplayCommentIndicator = xlCommentDisplayMode.xlNoIndicator 
Application.DisplayCommentIndicator = xlCommentDisplayMode.xlCommentIndicatorOnly
Application.DisplayCommentIndicator = xlCommentDisplayMode.xlCommentAndIndicator

Objects

alt text
ActiveWorkbook.DisplayDrawingObjects = xlDisplayDrawingObjects.xlDisplayShapes 
ActiveWorkbook.DisplayDrawingObjects = xlDisplayDrawingObjects.xlPlaceholders
ActiveWorkbook.DisplayDrawingObjects = xlDisplayDrawingObjects.xlHide

Window Options

alt text
ActiveSheet.DisplayAutomaticPageBreaks = True 
ActiveWindow.DisplayFormulas = True
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayOutline = False
ActiveWindow.DisplayZeros = False
ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayVerticalScrollBar = False
ActiveWindow.DisplayWorkbookTabs = False
ActiveWindow.GridlineColorIndex = 53

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrev