Close[1] but no cigar
99.9% percent of my Excel macros only affect the current file. If MS produced a macro mode that was unable to access anything outside of the current spreadsheet file in any way, then perhaps we could go back to being able to embed macros again without worrying?
This solution is nice for some things - and might drive solutions to use the scripting approach - but the fact that the scripts are local introduces a software distribution and installation problem that isn't there at the moment when a team of people need to use the same scripts. (Perhaps there's a 'group repository' option?)
[1] Actually not very close at all. :-(
Biting the hand that feeds IT
