Thanks for the macro. Tried it but it needs debugging for use with
Excel 2003.

Decided to take a fresh look in Visual Basic Editor to see if I could
spot anything. Discovered I had overlooked the existence of a module.
Although it was completely empty, it was still listed under
View>Project Explorer. I deleted that module and eureka, Excel no
longer thinks I have any macros.