Hiding an Excel Sheet with Password

**V.G.PADMANABHAN** · 10-31-2012, 12:36 AM

Dear Friend,

I did a 3 sheet Excel file, with a template in the sheet1, this will pick the datas from sheet2 & sheet3 for calculation.

I want to hide sheet2 & sheet3 and protect it with password.

Can any one help me to do it, please.

Thanks.

**grizzly6969** · 10-31-2012, 01:47 AM

this workbook has a code to view sheet 3 is this what you are looking to do

Please Login or Register  to view this content.

**benishiryo** · 10-31-2012, 01:53 AM

hi V.G.PADMANABHAN. do you need it to be protected to the extent they are 1) unable to unhide or 2) just unable to edit? for 1), try:

pressing ALT + F11. that will bring you to the VBA window. go to Tools -> VBAProject Properties -> Protection tab -> Lock project for viewing -> Enter password -> OK

go to View -> Project Explorer
go to View -> Properties window

you should now see 2 panels on the left. Under the 1st one, click on Sheet2 (Sheet2). now go to the 2nd panel. there should be a "Visible" field at the end. change it to "2 - xlsheetVeryHidden". do the same for Sheet3

for 2), simply:
right-click the worksheet name below & "Protect Sheet" Then type your password. right-click on the worksheet again & press "Hide"