Password Protection

[John Kitchens]

Hello I am using Excel 2000. Is there a way that I can password protect a
worksheet so that it can't be opened at all unless the user types in the
password?

I have a payroll information sensitive sheet that I don't want just anyone
looking at.

Any help would be appreciated.

Sincerely,
John Kitchens

 

[JulieD]

Hi John

worksheet or workbook?

if it's a workbook ... then choose files / save as ... click on tools /
general options
enter a password to open click OK - you'll be asked to confirm the
password - now anyone opening the file will need to enter the password
first.

if you want to hide a worksheet within a workbook ... hide the sheet and
then choose tools / protection / protect workbook .. enter a password ...
now they will need a password if they want to unhide the sheet - and
unfortunately, if they want to insert & delete other worksheets. You can
also make a sheet "very hidden" by using code. If you're interested in that
please post back and i'll dig out the notes.

Cheers
JulieD

 

[JE McGimpsey]

But since you said "can't be opened at all", you should realize that
even making the sheet "very hidden", it's possible for anyone with the
skill to find these newsgroups to break worksheet and workbook password
protection. If someone can open your file, you should assume that they
can see everything in it:

http://www.mcgimpsey.com/excel/removepwords.html

File protection takes significantly more effort, or a few bucks for a
commercial cracking service.

 

[JulieD]

Hi John

you're welcome, but please also take on board what Jim said about protection
in excel not being the strongest and consider keeping the file either in a
network folder and stopping people seeing or accessing the folder via
network permissions, or on a CD that you access when you need it but locked
somewhere safe when you don't.

Cheers
JulieD

 

[John Kitchens]

Julie,

It was a workbook and that did the trick! Thank you very much.

John Kitchens

 

[Dave Peterson]

J.E. McGimpsey = John (ExceptionallyTalented??) McGimpsey.

 

[JulieD]

Hi Dave

really? oops i've been calling him Jim for years ... apologies ...

Cheers
Julie

 

[Dave Peterson]

http://mcgimpsey.com

from near the bottom of that page:
John McGimpsey is the Principal, with other experts readily available for
projects in any of the areas above.

 

[Debra Dalgleish]

Well, JEM, JIM, it's pretty close.

I've misread a few things myself. <g>

Hi Dave

really? oops i've been calling him Jim for years ... apologies ...

Cheers
Julie

 

[JE McGimpsey]

Well, JEM, JIM, it's pretty close.

I've misread a few things myself. <g>

It's an occupational hazard - I use J.E. in my work, and as a Mac MVP,
it's helpful to distinguish myself from MVP John McGhie (i.e., to avoid
trashing his reputation when I answer Word questions).

I answer to just about anything...

 

[JulieD]

Hi JOHN

well a thousand apologies anyway ... and thanks for being to polite to
mention it when i've responded to your posts directly.

Cheers
JulieD