| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if Workbook is shared
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if Workbook is shared
Try this:
If ThisWorkbook.MultiUserEditing Then MsgBox "Shared" End If -- Dan On Apr 16, 10:05*am, Ladymuck 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if Workbook is shared
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 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook - Slow opening of shared workbook. | Excel Programming | |||
| VBA Code needs to check for Shared Workbook | Excel Programming | |||
| Check Box - are they possible with a shared workbook? | Excel Discussion (Misc queries) | |||
| Spell Check in Protected Worksheet & Shared Workbook | Excel Discussion (Misc queries) | |||
| Spell Check in Protected Worksheet & Shared Workbook continued | Excel Discussion (Misc queries) | |||
Linear Mode
