Hiding sheets with password

[howard]

I would like to know if there is a weay to hide sheets using a password? If so please let me know how to do this

 

[MarcelBeug]

Not directly, but you can first hide the sheet(s) and than protect your workbook.

 

[Michael M]

Do you want to do this with VBA ?

 

[howard]

Thanks for the help, much appreciated

 

[howard]

Hi Michael

My apologies. I wanted to be able to hide columnsI:L on sheet1 using a password to unhide.

It would be appreciated if you would be able to provide me with the code

 

[Penny Bangalore]

Hi Howard,

it can be done in very easy steps..
1 select entire sheet right click goto cells formating and click on protection and make sure the proteced is unchecked. and next come to sheet and select your range (i:L) and right click and goto cells formating and protection tab make sure hidden is checked and come to sheet select your range and righ click and hide .. Now goto review tab protect the worksheet with password and now it is hidden and you have to enter password to unhide it.

 

[howard]

Thanks very much for the info