Hiding Worksheets
 

In Excel 2007 is it possible to hide a worksheet within a workbook with
password protection so it cannot be viewed by others?

Thanks!

Steve

Hiding Worksheets
 

Open the VB Editor and in the Immediate Window use the first line below to
hide the worksheet
Make it visible again with the second line

worksheets("sheet2").Visible = xlSheetVeryHidden
worksheets("sheet2").Visible = true
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"RF Guy" <RF wrote in message
...
In Excel 2007 is it possible to hide a worksheet within a workbook with
password protection so it cannot be viewed by others?

Thanks!

Steve

Hiding Worksheets
 

First Hide all the rows and columns that have data on this worksheet. Then
go to Review Tab | Protect Sheet.

Then go to Home Tab | ckick Format | Hide & Unhide | Hide Sheet.

hope that helps.


"RF Guy" <RF wrote in message
...
In Excel 2007 is it possible to hide a worksheet within a workbook with
password protection so it cannot be viewed by others?

Thanks!

Steve