One workaround can be setting Application.screenupdating = false just
before you open it. and then set the same to TRUE when you want to make
it visible.
Hope it helps
Thanks and Regards,
Vivek Agrawal
Skype ID - vivek.agrawal83
GoogleMoonlight.com - Saving energy-Save Earth
On
Savio,
Place the following code in the Workbook_Open() event:
ThisWorkbook.Windows(1).Visible = False
If your workbook has more than one window, you'll need to iterate
through the Windows collection hiding them all.
Regarding breaking out of a loop or case, you could use a GoTo, though