The macro below which which came over from an unknown version of excel does not run. themecolor - tintandshade - patterntintandshade are all problems.
Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
' WhiteReset Macro
' Keyboard Shortcut: Ctrl+w
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.PatternTintAndShade = 0
.ColorIndex = xlAutomatic
.TintAndShade = 0
marking this as an enhancement, I don't currently have plans to look at this so putting back to default
Created attachment 162626 [details]
tintandshade demo file
BASIC runtime error.
attaching this file containing tintandshade. removing this from the macro makes the macro work just fine