| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test if File is Shared using VB
Using VB, I'm trying to test if the activeworkbook is shared.
Something like this, but it doesn't work. If ActiveWorkbook.ExclusiveAccess = False So how would I write this code? Thanks, Paul -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Test if File is Shared using VB
Nevermind, I think I got it.
If ActiveWorkbook.MultiUserEditing = True _ Thanks anyway. Paul -- "PCLIVE" wrote in message ... Using VB, I'm trying to test if the activeworkbook is shared. Something like this, but it doesn't work. If ActiveWorkbook.ExclusiveAccess = False So how would I write this code? Thanks, Paul -- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared File | Excel Discussion (Misc queries) | |||
| Shared file | Setting up and Configuration of Excel | |||
| Shared File | New Users to Excel | |||
| Open Test file with VBA with a changing file number | Excel Programming | |||
| shared file | Excel Worksheet Functions | |||
Linear Mode
