How Do I Hide A Worksheet

[Morrissey]

Tell Me Quick I Need To Know! I'm Nearly Finished!!

 

[teebruin]

With the sheet selected, go to Format - Sheet - Hide.

 

[Mark O'Brien]

Morrissey!!!! Yay!!!!

Do you want to know how through VBA or through clicking in Excel?

VBA:

<pre>
Sheets("Sheet1").Visible = xlVeryHidden</pre>

This will hide it to an extent that it can only be made visible again using code.

HTH

 

[Morrissey]

Its Done yay!