password protect a single sheet

[Guest]

hello all,
i was wondering if there is a way to password protect a worksheet. i have
many workbooks with multiple worksheets that people have access to. there are
sheets that people do not need to see. i know i can hide these sheets, but i
would rather have a password to open them so that if there are people who
need to open them they can by entering a password.
thank you for your time and have a great day!

 

[Guest]

i tried this and i see nothing changed. tools>protection>protect workbook>i
enterd password thinking it would ask me what i wanted to do but it did
nothing. any other suggestions would be appreciated.
thanks for the fast reply Stefi!

 

[Guest]

thank you both. i will give these a try.

 

[Zane Lassiter]

Stefi,
Studying this post and may need to do same. You stated "...protecting the
workbook: Tools/Protection/Protect workbook." For the life of me, I cannot
find Tools in the menu, in the ribbon, or in Office Button's Excel Options.
How do I get to Tools?

Thank you,
Zane

 

[Bob I]

Office Button, Save As, Tools, General.