I have a shared workbook on which I want to perform a VBA routine: On worksheet change, I want to lock the activcell. For some reason, it appears that the activecell property will not work in the shared workbook. Is this true for all shared workbooks? Can anyone suggest a workaround? (I don't want to lock the entire selection - I only want to lock the cell that changed.

Thank you
Gerry Maher