View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael[_15_] Michael[_15_] is offline
external usenet poster
 
Posts: 2
Default How to protect single cell or cells range from being over-written?

Hi,

I have finished a worksheet and pass it to my users, there are some fix
information stored in the some cells, which I don't want user to change,
and other cells are for user key in the data to be calculated...

Kindly pls tell me how to protect single cell or cells range instead of the
whole worksheet from being over-written?

Thanks
Michael