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
|