Disable macros on file open (Excel2000)

Topic

New Reply

I want to open a file from the File-Open dialog under VBA but I don’t want the macros in the selected file to run.
I seem to recall something like an ‘enableFileOpenMacros’ setting but my brain is in Friday mode.
Or do I turn ‘enableEvents’ off temporarily or something?

Any help much appreciated.

zeddy

Reply | Quote

Replies

Hold the shift key while clicking the Enable macros Button and while the file opens.

Reply | Quote

I can click the disable macros button.
But I want to do it in VBA.

zeddy

Reply | Quote

Try Disabling the events before opening

Steve

    Application.EnableEvents = False
    Workbooks.Open "c:Filename.xls"
    Application.EnableEvents = True 

Reply | Quote

Steve
Thanks for your reply – exactly right.

zeddy

Reply | Quote