How to make an excel file password protected

T

Terence

Dear all,

I would like to make an Excel file to be protected by a
password. I want it to ask for a password whenever "save"
is clicked. I tried to use the "Protect Workbook" function
but it seems doesn't work. Anyone knows the solution?
Thanks a lot.

Terence
 
D

Dave Peterson

I think I'd use the builtin workbook password protection. The user will be
prompted when they open the workbook--not when they try to save.

If that's ok:
While you're saving the file...

File|SaveAs|Tools|General Options|Change the password to modify to something
memorable.
(xl2002 wording)

File|SaveAs|Options (in earlier versions)
 
Top