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 !

G wrote:
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.

Thanks Andy,

Unfortunatly I am using Exel 2003 on Win XP

"Andy" wrote:

G wrote:
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.

Hi

You can do this in XL2003 as well.
ToolsProtectionProtect and Share Workbook

Regards

Roger Govier


G wrote:
Thanks Andy,

Unfortunatly I am using Exel 2003 on Win XP

"Andy" wrote:


G wrote:

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.

Hi Roger , got it thanks.

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

Thanks

"Roger Govier" wrote:

Hi

You can do this in XL2003 as well.
ToolsProtectionProtect and Share Workbook

Regards

Roger Govier


G wrote:
Thanks Andy,

Unfortunatly I am using Exel 2003 on Win XP

"Andy" wrote:


G wrote:

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.