Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a workaround | Excel Worksheet Functions | |||
Is it possible to put two different validations into one Cell or a workaround | Excel Programming | |||
Preventing sheet name changes (or a workaround) | Excel Programming | |||
Workaround for com exe timer?? help | Excel Programming | |||
csv load 64K workaround | Excel Worksheet Functions |