How to make an excel file password protected

  • Thread starter Thread starter Terence
  • Start date Start date
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
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Password Protection 7
Excel Opening Problems ? And, Other Equiv Spreadsheets ? 1
failure to password protect file 4
Password Protecting a workbook 2
How to Unlock Excel Workbook protected by MACRO Password 6
Password protected and shared workbook 1
What if I forgot the password protecting an excel workbook? 1

Back
Top