-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Opening a file using a macro
- Thread starter svmac
- Start date
NateO
Legend
- Joined
- Feb 17, 2002
- Messages
- 9,700
To disable events (i.e., workbook_open)
add: application.enableevents = false to your code.
Auto events (i.e., auto_open) will not run while opening a workbook with vba. Hold the shift key while closing it, if you're not closing it using vba.
Cheers, Nate
This message was edited by NateO on 2002-02-25 15:16
add: application.enableevents = false to your code.
Auto events (i.e., auto_open) will not run while opening a workbook with vba. Hold the shift key while closing it, if you're not closing it using vba.
Cheers, Nate
This message was edited by NateO on 2002-02-25 15:16
Upvote
0
