View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sgwapt[_2_] Sgwapt[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel file is locked by User X

When one person is in a file and someone else attempts to open the same file
the application pauses then prompts them with a message that "file is locked
by user X".

Is there a script statement that can be used to check this before the file
opens then not open the file to prevent the second user from clicking the
Read-Only button.

Thank you

--
Sgwapt