How do make cells F9:R1999 READ-ONLY ?
 

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/

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/

How do make cells F9:R1999 READ-ONLY ?
 

John Walkenbach has a good spiel on protection.

http://www.j-walk.com/ss/excel/faqs/protectionFAQ.htm

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
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

How do make cells F9:R1999 READ-ONLY ?
 

Thank you.



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