Password protect a sheet without Macros

[Guest]

Hi,

I am unfamiliar with using Macros, but need to password protect a sheet. I
am creating a form in Excel where suppliers can view "Sheet 1" but need a
password to enter into "Sheet 2". I don't want to hide the sheet either. Is
there any way I can do this without using Macros? And if not, can someone
please explain how to do this in the simpliest form.

Thanks so much

 

[Don Guillett]

tools>protection>protect sheet

 

[Guest]

I've tried that, but I don't want anyone to actually view the sheet only
those with a password. So when you click on "Sheet 2" it automatically askes
for a password to enter. Is this possible?

Thanks

 

[Don Guillett]

You would have to hide it and have it unhidden with a macro that asks for
the password.