ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel file is locked by User X (https://www.excelbanter.com/excel-programming/441287-excel-file-locked-user-x.html)

Sgwapt[_2_]

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


All times are GMT +1. The time now is 01:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com