View Tab


Show

microsoft excel docs
Application.ShowStartupDialog = False 
ActiveWindow.View.ShowHighlight = True
ActiveWindow.ShowBookmarks = False
Application.DisplayStatusBar = True
ActiveWindow.DisplayScreenTips = True

ActiveWindow.View.DisplaySmartTags = True
ActiveWindow.View.ShowAnimation = True
ActiveWindow.DisplayHorizontalScrollBar = True
ActiveWindow.DisplayVerticalScrollBar = True
ActiveWindow.View.ShowPicturePlaceHolders = False

Application.ShowWindowsInTaskbar = False
ActiveWindow.View.ShowFieldCodes = False
ActiveWindow.View.FieldShading = wdFieldShading.wdFieldShadingWhenSelected

Additional Right to Left Langauge Options

ActiveWindow.View.DisplayLeftScrollBar = True 
ActiveWindow.View.DisplayRightRuler = True

Formatting marks

microsoft excel docs
ActiveWindow.View.ShowTabs = False 
ActiveWindow.View.ShowSpaces = False
ActiveWindow.View.ShowParagraphs = False
ActiveWindow.View.ShowHiddenText = False
ActiveWindow.View.ShowHyphens = False
ActiveWindow.View.ShowAll = True

Print and Web Layout options

microsoft excel docs
ActiveWindow.View.ShowDrawings = False 
ActiveWindow.View.ShowObjectAnchors = False
ActiveWindow.View.ShowTextBoundaries = False
ActiveWindow.View.DisplayPageBoundaries = True
ActiveWindow.View.DisplayBackgrounds = False
ActiveWindow.DisplayVerticalRuler = True

You can only display a vertical ruler in Print Layout view.
You cannot display a vertical ruler unless the horizontal ruler is displayed (View > Ruler)


Outline and Normal options

microsoft excel docs
ActiveWindow.View.WrapToWindow = False 
ActiveWindow.View.Draft = False
ActiveWindow.StyleAreaWidth = Application.MillimetersToPoints(0)



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