Re: a certain Scottish Council
You can use Group Policy to disable all macros in Office.
Sure, Bob in accounts will be upset because the single Excel 97 spreadsheet that he uses for his custom reports uses all manner of ill advised macros in order to produce a report that nobody even looks at any more, but fuck Bob.