Password protect a sheet without Macros

C

Cappa

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
 
C

Cappa

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
 
D

Don Guillett

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