Check if Workbook is shared

's Computer Specifications

I would like an alert to pop up if someone tries to run a macro while the
workbook is in shared rather than exclusive mode. How would I do this?

Many thanks
Louise

's Computer Specifications

Try this:

If ThisWorkbook.MultiUserEditing Then
MsgBox "Shared"
End If

--
Dan

On Apr 16, 10:05*am, Ladymuck <Ladym...@discussions.microsoft.com>
wrote:
> I would like an alert to pop up if someone tries to run a macro while the
> workbook is in shared rather than exclusive mode. How would I do this?
>
> Many thanks
> Louise

's Computer Specifications

How simple is that! Thank you very much.

"Dan R." wrote:

> Try this:
>
> If ThisWorkbook.MultiUserEditing Then
> MsgBox "Shared"
> End If
>
> --
> Dan
>
>
> On Apr 16, 10:05 am, Ladymuck <Ladym...@discussions.microsoft.com>
> wrote:
> > I would like an alert to pop up if someone tries to run a macro while the
> > workbook is in shared rather than exclusive mode. How would I do this?
> >
> > Many thanks
> > Louise
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shared Workbook - Slow opening of shared workbook.	raul_madrigal@smbcgroup.com	Microsoft Excel Programming	2	29th Aug 2007 05:14 PM
VBA Code needs to check for Shared Workbook	=?Utf-8?B?TmV3Ynk=?=	Microsoft Excel Programming	0	26th Jul 2007 10:02 PM
Check Box - are they possible with a shared workbook?	=?Utf-8?B?TGlzYQ==?=	Microsoft Excel Misc	4	13th Feb 2007 02:42 PM
Spell Check in Protected Worksheet & Shared Workbook	=?Utf-8?B?RGF2ZXlDNFM=?=	Microsoft Excel Misc	6	28th Oct 2005 12:50 PM
Spell Check in Protected Worksheet & Shared Workbook continued	=?Utf-8?B?RGF2ZXlDNFM=?=	Microsoft Excel Misc	1	25th Oct 2005 06:15 PM