View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jaf jaf is offline
external usenet poster
 
Posts: 300
Default How do make cells F9:R1999 READ-ONLY ?

Hi Luther,
All cells are protected by default.
You need to turn off protection in the cells/ranges you DO want users to
edit in.

Select the range, then formatcells protection tab. Uncheck protect.

All you have to do is turn on worksheet protection.
Toolsprotectionprotect worksheet. Add a password if you wish.



--

John

johnf202 at hotmail dot com


"lothario" wrote in message
...
Hi,

I have one spreadsheet in one workbook.

Is there a way to make cells F9:R1999 READ-ONLY ?

So that the user is able view the contents of F9:R1999 but not change
them.

And the rest of the cells can be changed by anyone.

Thanks,
Luther



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/