It's a great idea, but I've been working in multiple enterprise excel hells and most of the places use macros, because the simple stuff just does not allow needed complexity.
What we have found is that one of the biggest problems in the BI space is the fact people are not able to code and resort to some of the horrific formulae we see. But agreed - including macros would add a huge new layer of complexity!
I much prefer reading Excel spreadsheet with complex formulae, than those with complex macros. It's much easier to follow things around and literally 'see' what's going on.