G
Guest
Have an old EXCEL file with macros written many years ago (perhaps Excel
4.0). Pretty complex macros. Excel 97 opens the file and runs the macros with
no problem. When trying to open the file on a computer with Excel 2000, the
file opens fine, but no acknowledgement of any macros is reported, and the
macros don't run. They do not appear on the MACROS list in either version of
Excel. I have changed the macro security to medium and low: still no
acknowledgement of any macros on the file. I did not write the macros, but I
see some formulas that look like: '{GOTO}A121~/WGRM{GOTO}AAK~3000 which I
had never seen before. When the file is opened in Excel 97, the macro is
activated and a Menu comes up with a list of letters (A to G) of the
different functions (macros, I assume) that can be invoked and that can be
activated by the Ctrl+letter sequence. Am I missing something somewhere?
Shouldn't the macro simply run?
4.0). Pretty complex macros. Excel 97 opens the file and runs the macros with
no problem. When trying to open the file on a computer with Excel 2000, the
file opens fine, but no acknowledgement of any macros is reported, and the
macros don't run. They do not appear on the MACROS list in either version of
Excel. I have changed the macro security to medium and low: still no
acknowledgement of any macros on the file. I did not write the macros, but I
see some formulas that look like: '{GOTO}A121~/WGRM{GOTO}AAK~3000 which I
had never seen before. When the file is opened in Excel 97, the macro is
activated and a Menu comes up with a list of letters (A to G) of the
different functions (macros, I assume) that can be invoked and that can be
activated by the Ctrl+letter sequence. Am I missing something somewhere?
Shouldn't the macro simply run?