Disabled macro going from Excel 2002 to Excel 2000

J

Jeff Melkonian

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
 
J

Juan Pablo González

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

--
Regards

Juan Pablo González

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
 
T

Tom Ogilvy

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Macros disabled, not by security settings? 9
VBA code won't run, even with Macro Security set to Enable All Macors 9
disabling macro message 0
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
Macros Disabled 1
Cannot run the macro 'XXX' 0
Error message: Macros in this project are disabled 1

Top