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

Top