How to check for Exclusive access to a workbook
Hi,
I've been trying this out for a while but am still scratching my head...
I need to check if an Excel Spreadsheet is already open by another user, so
that I don't open it if it is already being edited. Is there a way I can
determine this in Excel VBA?
I don't want the messagebox to come up stating that the sheet has macros
either, if this can be helped.
Many thanks in advance.
Andy
|