Hiding Worksheets

  • Thread starter Thread starter RF Guy
  • Start date Start date
R

RF Guy

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
 
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
 
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.
 
Back
Top