View Tab


Show

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

Comments

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

Objects

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

Window Options

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

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