Turning off the screen refresh at open can sometime speed it up a little
I think.......It allows macros to run in background without the need to
refresh the screen after every code.

You need to make sure you turn it back on once opened.

This works well during long codes connected to VB Controls.

Application.ScreenUpdating = False

Application.ScreenUpdating = True

It may help.......but others may have a better idea!

Celtic_Avenger


---
Message posted from http://www.ExcelForum.com/