| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open workbook using VBA but don't run macros
What is the line I can use to open a spreadsheet (123.xls say), but not run
the macros that are in the open event of 123.xls I can open the workbook using workbooks.open FileName:= "C:\123.xls" but the macros run. How do I do this? Is it possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open workbook using VBA but don't run macros
application.enableevents = false
workbooks.open filename:="C:\123.xls" application.enableevents = true You may want to do the same thing when you close the workbook. Paulymon wrote: What is the line I can use to open a spreadsheet (123.xls say), but not run the macros that are in the open event of 123.xls I can open the workbook using workbooks.open FileName:= "C:\123.xls" but the macros run. How do I do this? Is it possible? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open workbook without running Macros | Excel Programming | |||
| Turn Off Macros With Workbook Open | Excel Programming | |||
| Open workbook-macros enabled, opening another with macros | Excel Programming | |||
| Open workbook - prevent macros | Excel Programming | |||
| Can't open Excel2003 workbook containing VBA macros with Excel2000. | Excel Programming | |||
Hybrid Mode
