Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 vs Excel 2002 Macro | Excel Programming | |||
VBA - Macro backward compatibility from excel 2002 to excel 2000 | Excel Programming | |||
macros disabled after apply SP -3 to excel 2000 | Excel Programming | |||
Excel 2002 Macro Run button disabled? | Excel Programming | |||
macro written in Excel 2000 not working in Excel 2002 | Excel Programming |