share workbook

[Guest]

I have a workbook that is shared and used by many staff.
Is there a way to restrict who can share and unshare this workbook.. we have
staff who take it upon themselves to unshare from time to time !

 

[Andy]

I have a workbook that is shared and used by many staff.
Is there a way to restrict who can share and unshare this workbook.. we have
staff who take it upon themselves to unshare from time to time !

In Excel 2000, if you protect the workbook it cannot be unshared without
unprotecting first.

 

[Guest]

Thanks Andy,

Unfortunatly I am using Exel 2003 on Win XP

 

[Roger Govier]

Hi

You can do this in XL2003 as well.
Tools>Protection>Protect and Share Workbook

Regards

Roger Govier

 

[Guest]

Hi Roger , got it thanks.

This works however still allows users to remove other users which is
potentially still very hazerous.

Thanks