General Tab


Settings

microsoft excel docs
Application.ReferenceStyle = xlR1C1 
Application.IgnoreRemoteRequests = True
Application.DisplayFunctionToolTips = True
Application.PromptForSummaryInfo = True
Application.DisplayRecentFiles = True
Application.RecentFiles.Maximum = 9
Application.EnableSound = True
Application.RollZoom = True

The web options have not been included


Other

microsoft excel docs
Application.SheetsInNewWorkbook = 1 
Application.StandardFont = "Arial"
Application.StandardFontSize = "10"
Application.DefaultFilePath = "C:\Personal\Website\Other Files\"
Application.AltStartupPath = "C:\Personal\Website\"
Application.UserName = "Russell Proctor"

If the user name is left blank then Excel will substitute the name "User".
Options > VBA Code > Folder Paths


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