ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Test if File is Shared using VB (https://www.excelbanter.com/excel-programming/409523-test-if-file-shared-using-vbulletin.html)

PCLIVE

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

--




PCLIVE

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

--







All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com