Stupid Microsoft Tricks

I am working on a project to convert the prior programmer's horrible Excel "database" spaghetti code application into something that can actually be updated and maintained. Of course the end users, being accountants, want both the results and the interface to remain in an Excel workbook. Yeah, yeah, I can do that ...

Warning: Geeky programming stuff ahead!

( Enter the Stupidity For A New Age ... )

... and then I shot 'em.