View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ekazakoff Ekazakoff is offline
external usenet poster
 
Posts: 11
Default Sharing and protecting sections of a worksheet.

I have a workbook that I need other users to update. There is data I would
like to protect so I have unlocked the cells I want data entered into and
left the other cells locked. I would also like multiple users to be able to
access the file at the same time. When I used the share and protect
function however I discovered that the locked files could be overwritten so
the "protection" part of share and protect was not working properly. What am
I doing wrong?