share workbook
 

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 !

share workbook
 

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.

share workbook
 

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.

share workbook
 

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.

share workbook
 

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.