Protecting a shared worksheet

L

lostinformulas

I'm hoping someone can help me understand why my protect document isn't
totally protected. I have checked the options.

I have a shared workbook on a server, the protect cell will not allow
you to type in the cell, however if you copy and paste or drag the
formula down it is not protected.

Any help will be appreciated
 
Top