VBA Property to Determine if Multiple Workbooks Open 1

[bajo71]

Hello,

I am trying to determine if more than one user has a shared workbook open in Excel 2007. Thinking along this line...

If ActiveWorkbook.SharedWorkspace.Connected = True Then MsgBox "More than one user..."

Is there not a property setting that I can access?

Thanks.......Mickey

 

[Gavona]

Never used it but ActiveWorkbook.UserStatus looks promissing.



Gavin