General Tab
Settings
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
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