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 |