View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default read only and write only

Select the cells you want your users to be able to alter (CTRL + Clck if they
are not adjacent) and then:-

Format|cells|protection and remove the locked checkmark.

then

Tools|Protection|protect sheet.

User are now prevented from changing all cells except the ones you unlocked.

Mike

"zilah" wrote:

l would like to protect my work from other user not all but for the certain
column.for example ; column A 1,A2 ,A3 ,B1 B2,B3 ,C1,C2.C3 and D1.D2 D3 are
for write only.{ Column A23, A24,A25 ,B23,B24,B25 ,C23.C24,C25 and
D23,D24,D25 ,all the data here are copy from above like A23 is data from Al ,
so is it any way that the other user can,t change any data here}
thank you