View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shital shah shital shah is offline
external usenet poster
 
Posts: 61
Default access specific areas of a protected worksheet

Hi to all

I have Protected one Excel File which is open by more than 3 person. What i
want to do is there any way that if 1st person can open file than he can
only make change in column A to M only and if 2nd person can open that file
than he can only make changes in column N to AA. and 3d person can open that
file can only make changes in column AB to AG.

I am useing Excel 2000 any Help.
Thanks
****al