Advanced Tab
Application.CellDragAndDrop = True
Application.AlertBeforeOverwriting = True
Application.ExtendList = True
Application.AutoPercentEntry = True
Application.FixedDecimal = True
Application.FixedDecimalPlaces = 2
Application.CopyObjectsWithCells = True
Application.AskToUpdateLinks = True
Application.EnableAnimations = True
Application.MapPaperSize = False
Application.DefaultSheetDirection = xlLTR | xlRTL
ActiveSheet.DisplayRightToLeft = True
Application.CursorMovement = xlLogicalCursor | xlVisualCursor
Application.ControlCharacters = True
Application.TransitionMenuKey = "\"
Application.TransitionMenuKeyAction = xlExcelMenus | xlLotusHelp
Application.TransitionNavigKeys = True
ActiveSheet.TransitionExpEval = True
ActiveSheet.TransitionFormEntry = True
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\"
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrev