Uprotect sheet in shared document

[mike]

I have a protected sheet that needs to be occasional updated from another
workbook via a macro. The macro simply unprotects the shett, does it's thing
then reprotects it. I also wanted the user using the "protected sheet"
workbook, to be able to have it open while the updating takes place. this
works via sharing the workbook.

The issue is, it seems I cannot "unprotect" the sheet to update it while it
is shared.

Can anyone confirm that this is indeed impossible, or provide some insight
as to what I can do?

Thanks

Mike

 

[Simon Lloyd]

I have a protected sheet that needs to be occasional updated from
another
workbook via a macro. The macro simply unprotects the shett, does it's
thing
then reprotects it. I also wanted the user using the "protected sheet"
workbook, to be able to have it open while the updating takes place.
this
works via sharing the workbook.

The issue is, it seems I cannot "unprotect" the sheet to update it
while it
is shared.

Can anyone confirm that this is indeed impossible, or provide some
insight
as to what I can do?

Thanks

MikeMike, that is correct you can't manipulate a shared workbook that well,

shared workbooks are a nightmare!, you would be better off having a
linked workbook, and have the users workbook update links upon opening.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)