Detecting If Excel Workbook is already open 1

[OzzieOwl]

I have an Excel workbook, which several people use, however I need to restrict user opening an using the file on a read only basis. Can anyone tell me how to detect in VBA if the file has been opened on a read only basis, so I can then force the Excel sheet to close.

Any Help Greatly appreciated.

 

[dsi]

If ActiveWorkbook.ReadOnly = True 'It's Read-Only

You can also force it to be opened as read only in the SaveAs>Options menu.