password

H

Henry

I want to password protect my excel file(s)
but the Password option is not displayed in the Save As
Tools drop down menu?
Anybody have any ideas why it is not displaying?
 
D

Dan E

Henry,

To password protect your files you need to look under "Tools" ->
"Protection" then you need to decide wether you'd like to protect your sheet
or workbook...

Once you save a protected file next time you need to modify it you'll notice
the protection. To allow users to modify some values use the following
Hold down shift
Select the cells you'd like to have your users modify
Right Click -> Format Cells
Go to the protection tab
Uncheck Locked
OK

Dan E
 
N

Norman Harker

Hi Henry!

Password Protection for the workbook varies a little as between
Versions of Excel.

In XP you have two routes:

File > Save As > Tools > General Options

Or:

Tools > Options > Security

In Excel 2000:

File > Save As > Tools > General Options

In Excel 97:

File > Save As > Options


"Internal" Protection is a double system. Whether or not a sheet is
protected is controlled by Tools > Protection > Protect Sheet. What
users have access to when protection is in place depends upon whether
or not cells are locked or unlocked at the time protection is imposed.
The default is "locked" and needs changing before you imposed Tools >
Protection.

Workbook structure (ability to add sheets etc) and workbook windows
are also controlled from the Tools > Protection menu.

Be aware that internal protection in Excel is not really designed to
do more than protect against accidental erasing of data and formulas
and to assist users in entering data in limited cells only. Removal of
passwords is very easy to achieve with freely available password
removers. Workbook protection is a little more secure but quite a few
organisations sell password breaking programs for very low prices.

--
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Friday: Belgium (Flemish Community Holiday and
Guldensporenslag); France (La Fete de la Magdalene); International
(World Population Day); Italy (St. Rosalia Day); Mongolia (Revolution
Day).
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
N

Norman Harker

Hi Henry!

I can't say that I've seen this before. So let's see if we can get
some more data to go on.

What is version of Excel on the computer that is behaving unusually.
Are you sure tat the file being opened as a password on it. (Check
with the computer it was saved on and another computer).

When is it not displaying this password prompt.

Does it happen with all files saved with passwords

Does it happen with files saved with a password on it's own computer
or just with others.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 15th July: Brunei Darussalam (Sultan'
s Birthday); Ukraine (Holy Trinity); United Kingdom (St. Swithin's
Day); Observances: O-Bon / Festival of Souls (Shinto)
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
N

Norman Harker

Hi Henry!

Are you sure that you are using:

File > Save As > Tools > General Options
Fill in and confirm the two password options.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Wednesday 23rd July: Armenia (Martyr's Day),
Egypt (Revolution Day), Equatorial Guinea (Bata's Fiesta), Fiji
(Constitution Day), Indonesia (National Children's Day), Oman
(National Day), Papua New Guinea (Remembrance Day), Syria (Egyptian
Revolution Day). Observances: Rastafarian (Birthday of Haile
Selassie), Neptunalia (Roman)
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top