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