View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andy Andy is offline
external usenet poster
 
Posts: 414
Default 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