application.enableEvents
 

Hi all,
I'm trying to have a macro copy/pastespecial a cell from another workbook.
Simple enough but I have a userform that shows when the workbook opens so I
have to close the form to continue the macro. I "thought"
application.enableevents=false would stop this userform from opening but
obviously I'm wrong.
Any help is always appreciated.

Workbooks.Open FileName:="C:\Report1.xls"

Application.EnableEvents = False

Sheets("A").Select
Range("D5").Select
Selection.Copy
yaddayaddayadda


--
jeffP

application.enableEvents
 

Jeff,

Put EnableEvents = False BEFORE opening the workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"jeffP" wrote in message
...
Hi all,
I'm trying to have a macro copy/pastespecial a cell from
another workbook.
Simple enough but I have a userform that shows when the
workbook opens so I
have to close the form to continue the macro. I "thought"
application.enableevents=false would stop this userform from
opening but
obviously I'm wrong.
Any help is always appreciated.

Workbooks.Open FileName:="C:\Report1.xls"

Application.EnableEvents = False

Sheets("A").Select
Range("D5").Select
Selection.Copy
yaddayaddayadda


--
jeffP