The Workbooks.Open command is setting it back to true. I tried adding

With driverFile
..Application.ScreenUpdating = false
End With

and it did turn back off, but after printing the newly opened book to
the screen

Wait, I just figured it out, the workbook I am opening also disables
screen updating and reenables it in its open event. How can I get
around this? Is there a way to open the file and disable its macros?
(That doesn't seem to be a parameter for the open method)


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