Found a workaround
 

I have also been struggling with macros for some time and found a workaround. It takes a few steps, but it worked and I am happy enough.

Load your excel spreadsheet in Compatability Mode, or save it to begin with as an Excel 2003 file.

If you have a large file and are not sure if there are hyperlinks or other hypertext in them, copy the spreadsheet.

Open a new spreadsheet, click on Paste Special... under the paste icon.

In the popup box, click the "Paste Link" button inthe lower left-hand corner.

This will paste the sheet in a plain text, unformatted environment, similar to the previous post using Notepad, but you can stay in Excel to do this.

My Macros work beautifully as before.

Norma