Password protect a sheet without Macros
 

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

Password protect a sheet without Macros
 

toolsprotectionprotect sheet

--
Don Guillett
SalesAid Software

"Cappa" wrote in message
...
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

Password protect a sheet without Macros
 

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" wrote:

toolsprotectionprotect sheet

--
Don Guillett
SalesAid Software

"Cappa" wrote in message
...
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

Password protect a sheet without Macros
 

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

--
Don Guillett
SalesAid Software

"Cappa" wrote in message
...
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" wrote:

toolsprotectionprotect sheet

--
Don Guillett
SalesAid Software

"Cappa" wrote in message
...
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