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.


--
Regards,
Tom Ogilvy

"Doug Kanter" wrote in message
...

"Pete" wrote in message
ups.com...
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".