Some problems with shared workbooks
 

I have some problems with shared workbooks using VBA:

1) How to check if active workbook is shared or not (using VBA)?

2) How to share workbook during closing it (in the Workbook_BeforeClose
procedure)?

3) How to check if somebody else is using shared workbook at the moment
(except me)?

Leszek