Excel Office 2007 Password protect worksheet

L

Lori

How do I password protect a worksheet where the reader cannot open unless
they have the password and once opened it is in "read only" mode.

Thanks!
 
B

Bernard Liengme

Office button / File Save As /
On the Save dialog, lower left corner there is a Tools button, press this
On the drop down menu, select General Options
This give a dialog where you set the password and the read-only option

best wishes
 

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

Protect Workbook based on Date 3
protecing hidden columns 1
Different password for different worksheet 11
Protect a worksheet with a password 2
Userinterfaceonly 5
Protecting/Unprotecting all sheets with macro leads to "image" iss 3
allow a user to edit ranges in a protected worksheet 3
Is there a way that I can password protect a worksheet 3

Top