Preventing Users from Unsharing Shared Workbook

[Peeekay]

I have a workbook which is shared among a number of users - they need to
add/amend data in the worksheets - but every now and again some 'accidentally'
unshares the file - is there a way to prevent them doing this while
maintaining their access to the file?


Thanks for the help

[Whizbang]

In the Review tab, selec the "Protect and Share Workbook" option. From here you can enter a password that a user would need to enter to unshare the workbook.

See this link for more details.
http://www.java2s.com/Tutorial/Micro...edworkbook.htm

[Peeekay]

That was easy.

Thank you very much.