Opening a file using a macro

svmac · Feb 25th, 2002, 08:13 PM

I wish to open a file using a macro (which I can do OK) but I want to disable the macros in the new file - any help is appreciated.

Thnx
Stuart

NateO · Feb 25th, 2002, 09:02 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 08:13 PM	#1
svmac Join Date: Feb 2002 Location: Adelaide, Australia Posts: 182	I wish to open a file using a macro (which I can do OK) but I want to disable the macros in the new file - any help is appreciated. Thnx Stuart

Feb 25th, 2002, 09:02 PM	#2
NateO MrExcel MVP Admin Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,639	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 ]