Two things that could be the cause of your problems.

1. The cells you wish to protect are not 'locked' - Check this out by
seleceting the cells, going to Format -- Cells -- Protection and making
sure the 'locked' box is ticked.

2. Have you supplied a password with your locking / unlocking command, it
should look like this

ActiveSheet.Unprotect Password:="Password"

HTH

Neil
www.nwarwick.co.uk

"Mike" wrote:

I have a workbook that needs to be shared across a network, but when shared
the ActiveSheet.Protect / Unprotect command does not appear to work while in
although everything works Ok when in exclusive access.
Is there any way around this with out having to manually turn off 'Share
Workbook', running the macro's and then turning it back on again ?