Alright, I am assuming this is possible but can't seem to get it to work. The help in Excel tells me it will do it but doesn't work and can't find anything on this specifically looking on the net

I want to hide sheets in a excel spreadsheet and have people have to use a password to unhide them. Is this possible?

Everytime I protect them and then hide them I can unhide them with no password being asked for.

<----- Excel novice

 

I don't know if this is what you want but try doing: File - Save As - Tools (a drop bar) - General Options... mine won't let me open without a password. click the box "Read Only Recommended" if you don't want people to even see a read-only copy

 

Hide the sheet and then protect the entire workbook for structure.

 

I'm not sure that you can hide sheets. You can definitely hide rows and/or columns, though.

If you protect the sheet or workbook, that should prevent them from unhiding without the password. Or you can just protect without hiding and they will be able to see the info, but not change it.

Edit: Help ownz me. So, yeah. What Jimmy said.

 

Format>Sheet>Hide

But protecting the sheet doesn't keep someone from unhiding it, hence why I think you have to protect the entire workbook to prevent it. You can't unhide the sheet without unprotecting the workbook

 

maybe something with Visual Basic code that Excel has might have something to do with it

<----personally hates Visual Basic

 

what jimmy carter said.. u would have to do it after u hide it..

 

what threw me off was this quote in the help file

"To prevent others from displaying hidden sheets, rows, or columns, you can protect the workbook or sheet with a password"

works.

Thanks