Open a workbook without activing Auto_Open macro

Captain Smith

Active Member
Joined
Feb 28, 2003
Messages
324
Hi. My active workbook is named Cat. Using VBA, I wish to open a second workbook named Dog that is in the My Documents folder on the C drive. Problem is that Dog has an Auto_Open macro which I want to not run when this workbook opens. How would I go about doing this? Thanks.
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,282
Try setting
Application.EnableEvents = False
before opening the workbook, and re-setting events to True afterwards.

Be aware, if the macro errors, EnableEvents does not reset, so maybe use an error handler that re-enables the events to cover your bases.
 
Upvote 0

Forum statistics

Threads
1,187,187
Messages
5,962,101
Members
438,583
Latest member
DJTCharts

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top