VBA - Advanced Tab
Editing Options
Application.MoveAfterReturn = True
Application.MoveAfterReturnDirection = xlDirection.xlDown
Application.EditDirectlyInCell = True
Application.EnableAutoComplete = True
Application.UseSystemSeparators = True
Application.DecimalSeparator = "."
Application.ThousandsSeparator = ","
Cut, Copy, and Paste
Application.DisplayPasteOptions = True
Application.DisplayInsertOptions = True
File Open Preference
Pen
Image size and quality
Print
Chart
Display
Application.ShowStartupDialog = True
Application.DisplayFormulaBar = True
Application.DisplayStatusBar = True
Application.ShowWindowsInTaskbar = True
Application.DisplayCommentIndicator = xlCommentDisplayMode.xlNoIndicator
Application.DisplayCommentIndicator = xlCommentDisplayMode.xlCommentIndicatorOnly
Application.DisplayCommentIndicator = xlCommentDisplayMode.xlCommentAndIndicator
ActiveWorkbook.DisplayDrawingObjects = xlDisplayDrawingObjects.xlDisplayShapes
ActiveWorkbook.DisplayDrawingObjects = xlDisplayDrawingObjects.xlPlaceholders
ActiveWorkbook.DisplayDrawingObjects = xlDisplayDrawingObjects.xlHide
ActiveSheet.DisplayAutomaticPageBreaks = True
ActiveWindow.DisplayFormulas = True
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayOutline = False
ActiveWindow.DisplayZeros = False
ActiveWindow.DisplayHorizontalScrollBar = False
ActiveWindow.DisplayVerticalScrollBar = False
Display options for this Workbook
ActiveWindow.DisplayWorkbookTabs = False
Display options for this Worksheet
ActiveWindow.GridlineColorIndex = 53
Formulas
When calculating this workbook
ActiveWorkbook.UpdateRemoteReferences = True
ActiveWorkbook.PrecisionAsDisplayed = True
ActiveWorkbook.Date1904 = True
ActiveWorkbook.SaveLinkValues = True
ActiveWorkbook.AcceptLabelsInFormulas = True
General
Application.AskToUpdateLinks = True
Application.AltStartupPath = "C:\Personal\Website\"
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext