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