Disabled macro going from Excel 2002 to Excel 2000
 

Hi,
I wrote VB code for an application in Excel 2002
(10.3506.3501) SP-1. A person attempted to run the application
using Excel 2000, Ver 9.0.6926 SP-3 and reported that, when
they accessed the Excel workbook with the application, they
got a message that the "macros are disabled". When the
person clicked on the Macro button, they got a message:
"Microsoft Visual Basic. The macros in this project are
disabled. Please refer to the online help or documentation of
the host application to determine how to enable macros." Does
anyone know how to handle this problem?

Thanks,

Jeff Melkonian

Disabled macro going from Excel 2002 to Excel 2000
 

Tools | Macro, Security. Set it to "Medium"

--
Regards

Juan Pablo González

"Jeff Melkonian" wrote in message
...
Hi,
I wrote VB code for an application in Excel 2002
(10.3506.3501) SP-1. A person attempted to run the application
using Excel 2000, Ver 9.0.6926 SP-3 and reported that, when
they accessed the Excel workbook with the application, they
got a message that the "macros are disabled". When the
person clicked on the Macro button, they got a message:
"Microsoft Visual Basic. The macros in this project are
disabled. Please refer to the online help or documentation of
the host application to determine how to enable macros." Does
anyone know how to handle this problem?

Thanks,

Jeff Melkonian

Disabled macro going from Excel 2002 to Excel 2000
 

Is security set to high?

If so, macros in workbooks that are not certified by a user selected trusted
source are disabled silently. Set security to medium.

--
Regards,
Tom Ogilvy

"Jeff Melkonian" wrote in message
...
Hi,
I wrote VB code for an application in Excel 2002
(10.3506.3501) SP-1. A person attempted to run the application
using Excel 2000, Ver 9.0.6926 SP-3 and reported that, when
they accessed the Excel workbook with the application, they
got a message that the "macros are disabled". When the
person clicked on the Macro button, they got a message:
"Microsoft Visual Basic. The macros in this project are
disabled. Please refer to the online help or documentation of
the host application to determine how to enable macros." Does
anyone know how to handle this problem?

Thanks,

Jeff Melkonian