View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nospam nospam is offline
external usenet poster
 
Posts: 16
Default selective protection

Hi,

excel 2002 (10.6789) sp3 office XP


is it possible to protect some cells on a sheet?


I have a sheet that I want users to enter data into some cells and other
cells (which have formula in them) will display the results.

I want to protect, if that is the correct terminology, the cells with
the formula so it they don't get deleted or modified by mistake.


The protection option just protects all the cells so data cant be added.

Or I'm I trying to do something that is impossible?

Thanks for any help.


--
Nospam