Prev: Alternative way to show 12 tabs??
Next: Select 'used range' except header row in excel 2007
From: Les Allan on 29 Mar 2010 08:31
I've got a workbook with a lot of code and want to prevent users from
sharing the workbook. If they share the workbook, it only generates
error messages for them and creates problems.

If I could hide the command bar option or catch when they go to share
the workbook and cancel the action, that would be great. But I
searched high and low on how to do this with no luck. Users will be
using XL 2002 up to 2007. Does anyone have any ideas or faced this
challenge before?

Les
From: Les Allan on 29 Mar 2010 18:21
Thanks John,

That works like a charm in XL 2003. It would be a treat if I can also
stop XL 2007 users from sharing the workbook. I thought of capturing
the user clicking on the share workbook option in the
Workbook_BeforeSave procedure with something like:

With ThisWorkbook
If .MultiUserEditing Then
<code that cancels sharing>
End If
End With

But this only triggers once the workbook is already saved. Has anyone
else tried to prevent w/b sharing in XL 2007? Or what do other people
do with users that try to share a w/b that will lead to errors if
shared?

Les
 | 
Pages: 1
Prev: Alternative way to show 12 tabs??
Next: Select 'used range' except header row in excel 2007