| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop macro when open excel from VBA
Hello,
I have created a code to open other excel files. However, in some of the excel files, there are some auto-run macro. When I open these files via VBA, their auto-run macro will be executed, which leads to error. If it is possible to stop these auto-run macro when I open them via VBA. My excel version is Excel 97 SR-2. The command to open the file are as following: Workbooks.Open FileName:="Test.xls",_ updatelinks:=False, _ ReadOnly:=True Best Regards Bill |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Stop macro when open excel from VBA
If you turn off events before opening the workbook you should be okay.
Application.EnableEvents = False And then turn events back on. -- Jim Rech Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop a toolbar that always turns on when I open Excel? | Setting up and Configuration of Excel | |||
| How to stop message popping up before open the excel? | Excel Discussion (Misc queries) | |||
| When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
| How to stop file open macro prompt after deleting all macros? | Excel Worksheet Functions | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
Hybrid Mode
