File Protection

  • Thread starter Thread starter Roger R
  • Start date Start date
R

Roger R

Can you protect a file so that you are unable to open or
view that file without a password?

Thanks in advance.
Roger
 
Yes
File Save As Tools General Options Enter password in box

: Can you protect a file so that you are unable to open or
: view that file without a password?
:
: Thanks in advance.
: Roger
 
Hi Roger R!

In all Versions it is under the Save As dialog but there are
variations:

Excel 97 and, I believe, before
File > Save As

Press Options Button

Select from alternatives available

Impose or Change password

OK

Re-confirm password or passwords

OK

Save

With Excel 2000:
File > Save As > Tools > General Options

Select from alternatives available

Impose or Change password

OK

Re-confirm password or passwords

OK

Save

With Excel 2002(XP) and 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.
 
Back
Top