Tried Application.ScreenUpdating = False before it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TommySzalapski"
<TommySzalapski.1sw37v_1122570430.5024@excelforu m-nospam.com wrote in
message news:TommySzalapski.1sw37v_1122570430.5024@excelfo rum-nospam.com...

Is it possible to hide a workbook instantly when it opens?
I currently have

Set newBook = Workbooks.Open(fileName)
Windows(fileName).Visible = False

I also tried

Set newBook = Workbooks.Open(fileName)
With newBook
Windows(fileName).Visible = False
End With

In both cases the workbook flashes on the screen for an instant.
That's clumsy. Is there a way to prevent that without saving the
workbook as hidden?

Thanks


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile:
http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=391021