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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding worksheets 7
Blocking/Disabling selected worksheet 1
protecing hidden columns 1
Excel Protection 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Password protect worksheets from being viewed within a workbook 1
Different Passwords for different worksheets in one workbook 8
Hiding/Unhiding Rows Automatically 1

Back
Top