How do you password protection from viewing a worksheet

  • Thread starter Thread starter Bill Artman
  • Start date Start date
B

Bill Artman

I am using Excel 2002 and would like to password protect
a worksheet so my employees can not view the worksheet.
The help files and knowledge base tell how to password
protect from making any changes but not how to protect
against a person opening the worksheet file. The
worksheet that I want to keep my employees from
viewing/opening contains payroll data. I hope there is a
way to do this. Thanks for your help!

Bill Artman
 
Hi Bill!

Imposing and Changing Protection of Workbooks


With Excel 2002 (XP) and Excel 2003


Two routes are now available:



Tools > Options > Security

Select from alternatives available

Impose or Change password

Re-confirm password or passwords

OK



OR (As before with Excel 2000)



File > Save As > Tools > General Options

Select from alternatives available

Impose or Change password

Re-confirm password or passwords

OK

Save


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Bill,
You could Hide the worksheet and then turn on worksheet protection.

Tools>Protection>Protect_Workbook
Select Structure and password protect.

Good Luck,
Mark Graesser
(e-mail address removed)

----- Bill Artman wrote: -----

I am using Excel 2002 and would like to password protect
a worksheet so my employees can not view the worksheet.
The help files and knowledge base tell how to password
protect from making any changes but not how to protect
against a person opening the worksheet file. The
worksheet that I want to keep my employees from
viewing/opening contains payroll data. I hope there is a
way to do this. Thanks for your help!

Bill Artman
 
File Save as, go to Tools, enter password to open file


: I am using Excel 2002 and would like to password protect
: a worksheet so my employees can not view the worksheet.
: The help files and knowledge base tell how to password
: protect from making any changes but not how to protect
: against a person opening the worksheet file. The
: worksheet that I want to keep my employees from
: viewing/opening contains payroll data. I hope there is a
: way to do this. Thanks for your help!
:
: Bill Artman
 
Back
Top