![]() |
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 -- |
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