Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros when loading a Workbook in Excel 2000
Hey
Is there a way to switch off macros when you open a workbook with Excel 2000 via Automation? I know there is the excelApp.AutomationSecurity = soAutomationSecurity.msoAutomationSecurityForceDis able; in Excel 2003, but that is not around for 2000 yet. Also, setting EnableEvents = false is not working either. Seems to be a bug according to MS. Thanks Remy Blaettler www.collaboral.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros when loading a Workbook in Excel 2000
Can you open the workbooks after you disable events:
dim wkbk as workbook application.enableevents = false set wkbk = workbooks.open(...) application.enableevents = true And if you do anything to the workbook, turn off events before you do it. Wouldn't that be the equivalent of disabling macros??? Remy wrote: Hey Is there a way to switch off macros when you open a workbook with Excel 2000 via Automation? I know there is the excelApp.AutomationSecurity = soAutomationSecurity.msoAutomationSecurityForceDis able; in Excel 2003, but that is not around for 2000 yet. Also, setting EnableEvents = false is not working either. Seems to be a bug according to MS. Thanks Remy Blaettler www.collaboral.com -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros when loading a Workbook in Excel 2000
Dave, I think he has tried that and is making reference to this article:
http://support.microsoft.com/default...b;en-us;211626 XL2000: EnableEvents Property Does Not Work in Automation Server So the solution for that case is a macro run from within Excel that disables events. How that is implemented by the OP is their decision. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Can you open the workbooks after you disable events: dim wkbk as workbook application.enableevents = false set wkbk = workbooks.open(...) application.enableevents = true And if you do anything to the workbook, turn off events before you do it. Wouldn't that be the equivalent of disabling macros??? Remy wrote: Hey Is there a way to switch off macros when you open a workbook with Excel 2000 via Automation? I know there is the excelApp.AutomationSecurity = soAutomationSecurity.msoAutomationSecurityForceDis able; in Excel 2003, but that is not around for 2000 yet. Also, setting EnableEvents = false is not working either. Seems to be a bug according to MS. Thanks Remy Blaettler www.collaboral.com -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros when loading a Workbook in Excel 2000
I remember skimming by that thread. Thanks for the solution (I'll speak for the
OP!). Tom Ogilvy wrote: Dave, I think he has tried that and is making reference to this article: http://support.microsoft.com/default...b;en-us;211626 XL2000: EnableEvents Property Does Not Work in Automation Server So the solution for that case is a macro run from within Excel that disables events. How that is implemented by the OP is their decision. -- Regards, Tom Ogilvy "Dave Peterson" wrote in message ... Can you open the workbooks after you disable events: dim wkbk as workbook application.enableevents = false set wkbk = workbooks.open(...) application.enableevents = true And if you do anything to the workbook, turn off events before you do it. Wouldn't that be the equivalent of disabling macros??? Remy wrote: Hey Is there a way to switch off macros when you open a workbook with Excel 2000 via Automation? I know there is the excelApp.AutomationSecurity = soAutomationSecurity.msoAutomationSecurityForceDis able; in Excel 2003, but that is not around for 2000 yet. Also, setting EnableEvents = false is not working either. Seems to be a bug according to MS. Thanks Remy Blaettler www.collaboral.com -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Macros when loading a Workbook in Excel 2000
The problem is that the macro is executed in the Open event in Excel,
so until I can call a macro to switch of Macros, it's already too late. Remy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I disable the automatic virus scan when loading Excel 2007 | Setting up and Configuration of Excel | |||
Disable VBA code execution when loading a workbook | Excel Discussion (Misc queries) | |||
Disable Macros in workbook programmatically | Excel Programming | |||
Disable or remove macros for a workbook to be sent in email... | Excel Programming | |||
Disable Macros when opening workbook | Excel Programming |