View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com is offline
external usenet poster
 
Posts: 96
Default 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