Password Protection

[Susan]

I couldn;t find this question anywhere on this forum, so I hope I'm not
wasting anyone's time...I sent an Excel worksheet to a friend via email. I
passworded it first. She said she didn't need any password to open it. Is
the password protection only valid for the PC on which it was created? Is
there any way to protect a worksheet that is to be emailed? TIA!

 

[Don Guillett]

Maybe you really didn't save after protecting or what did she use to open?

 

[Pete]

When you password-protect a file it doesn't stop other people from
opening the file, but it does prevent them from changing the formulae
(by accidentally entering another value), or from changing the formats
(and column widths). You can set the file up so that they can only
enter data into cells which you have selected, so they can use your
file but they can not change the parts which you don't allow them to.

Hope this helps.

Pete

 

[Tom Ogilvy]

there are several levels of password protection.

Worksheet and workbook are applied under the tools menu. File level is done
as part of the SaveAs dialog. This file level protection is the only level
that requires a password to open the file. The others protect the content,
but not from viewing. the is also protection for VBA code in the workbook,
but this doesn't appear applicable here.

All levels of passsword protection can be broken with existing password
crackers designed for the job.

 

[Doug Kanter]

When you password-protect a file it doesn't stop other people from
opening the file, but it does prevent them from changing the formulae
(by accidentally entering another value), or from changing the formats
(and column widths). You can set the file up so that they can only
enter data into cells which you have selected, so they can use your
file but they can not change the parts which you don't allow them to.

Hope this helps.

Pete

Huh? In Excel 2000, a password, when applied correctly, most certainly DOES
keep the sheet from being opened. I've been doing this for years. Has
Microsoft removed this capability in subsequent versions?

- File, Save As
- Click on "Tools", then "General Options"
- I'm presented with a box showing "Password to modify" and "Password to
open".

 

[Tom Ogilvy]

I passworded it first.

I don't see where she specifically said she used File Save As . . .

Since the recipient was able to open it without a password, good chance that
she used Workbook or worksheet protection under tools.

Has Microsoft removed this capability in subsequent versions?

No.

 

[Susan]

Thanks for the responses. I used Excel 97, she used 2003(XP). I gave her
the password, as I wanted her to be able to open it, but she said it came
right up. I checked it beforehand, and I needed to put in the password. Not
a big deal...just wondering if there was a way to protect it for things like
email, etc. Thanks anyway.

 

[Doug Kanter]

Are you saying that after reading the responses, you were UNABLE to make the
password thing work the way you wanted?

 

[nqluu]

Regarding exel password, I have other problem. I put password in an exel
file to protect it but now, I canot remember the password to open the
file
I try many times but could not make it. It's siad that there are
softwares to recover the password?

Could you please help me?

Thanks alot.

 

[Norman Jones]

Hi Nqluu,

See Je McGimpsey at:

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

and

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