Password protect & read only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to know how to protect a worksheet with "read only/view" capability. I am able to password protect the worksheet, however other users cannot view the spreadsheet without the password, I need to know how they can view without a password.
 
Just put a password in the modify box only - Users will still get the password
prompt but will be able to click on the 'Read Only' option.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



ANGELA said:
I would like to know how to protect a worksheet with "read only/view"
Click to expand...
capability. I am able to password protect the worksheet, however other users
cannot view the spreadsheet without the password, I need to know how they can
view without a password.
 
Back
Top