I had to export all the VBA code, set up a new spreadsheet, go
into VBE and check all the right boxes. Then I imported the code.
This worked fine.

Thanks for the pointers. Alan