View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default Excel Office 2007 Password protect worksheet

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Lori" wrote in message
...
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!
--
Lori