$$Excel-Macros$$ Re: Code to hide workbook

2009-08-12 Thread vivek agrawal
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

$$Excel-Macros$$ Re: Code to hide workbook

2009-08-12 Thread Chris Spicer
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