Excel VBA

How do you open an excel workbook that has an On_Open() event that you don't want to execute?
Who is Participating?
R_RajeshConnect With a Mentor Commented:
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"

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.