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