Hiding Worksheets

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
 
B

Bernard Liengme

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
 
G

Gaurav

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
can hidden sheets be prevented from opening without a password? 2
Password protect worksheets from being viewed within a workbook 1
Blocking/Disabling selected worksheet 1
Copy protection from one worksheet to another 2
Excel 2007 sheet and workbook protection 7
How do I apply print settings to all worksheets 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Top