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