• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • Last Modified:

Excel VBA

How do you open an excel workbook that has an On_Open() event that you don't want to execute?
0
Nobletucky2004
Asked:
Nobletucky2004
1 Solution
 
R_RajeshCommented:
if you are opening it manually then you can either set the macro security to high or hold down the shift key while opening the file.

if you are doing it through code then then set the application's AutomationSecurity property to msoAutomationSecurityForceDisable

Application.AutomationSecurity = msoAutomationSecurityForceDisable
Workbooks.Open "c:\MyFile.xls"

Rajesh
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now