| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for Shared Workbook
I need to check to see if a workbook that resides on a networked drive has
been set to "shared" mode (Tools, Share Workbook...). Is that possible, using VBA? If so, can someone please direct me to where I can find some sample code? (I'm a VBA novice.) Thanks in advance for any help. Bob |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for Shared Workbook
Maybe (is the workbook open?)...
MsgBox ThisWorkbook.MultiUserEditing Bob wrote: I need to check to see if a workbook that resides on a networked drive has been set to "shared" mode (Tools, Share Workbook...). Is that possible, using VBA? If so, can someone please direct me to where I can find some sample code? (I'm a VBA novice.) Thanks in advance for any help. Bob -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for Shared Workbook
Dave,
I looked up the MultiUserEditing property in Excel's help file. It appears that it may do the trick. I'll have to test it out. Thanks for pointing me in the right direction. I really appreciate it. Bob "Dave Peterson" wrote: Maybe (is the workbook open?)... MsgBox ThisWorkbook.MultiUserEditing Bob wrote: I need to check to see if a workbook that resides on a networked drive has been set to "shared" mode (Tools, Share Workbook...). Is that possible, using VBA? If so, can someone please direct me to where I can find some sample code? (I'm a VBA novice.) Thanks in advance for any help. Bob -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shared workbook is set up is not 'shared' on network | Excel Worksheet Functions | |||
| shared workbook - shared workbook options grayed out | Excel Discussion (Misc queries) | |||
| Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
| Testing if a workbook is open | Excel Programming | |||
| update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
