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


© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

PrevNext