how do I run excel 4.0 macros on excel 2000

[RodolfoDallas]

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?

[Mike Middleton]

RodolfoDallas -

Looks like keystroke-based Lotus 1-2-3 macros. According to Excel's Help:

Microsoft Excel 2000 and later versions do not run Lotus 1-2-3 macros.

- Mike
www.mikemiddleton.com

"RodolfoDallas" <RodolfoDallas@discussions.microsoft.com> wrote in message
news:C9EC408D-6197-40DA-A6B5-656C9B69D349@microsoft.com...
> 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?