when use vba to open file, How to notify the user when the excel are opened by other

[mrkhchan]

Hi all,

I use the vba to open excel file. like workbooks.open filename:=abc.xlsm
but I found that if the file is opened by other. Excel still open the file but it will not notify user that it is opened as read only.

Would you add more line to notify user if the file is opened by other?

Many thanks.

[Mumps1]

This macro will notify you whether or not the workbook is open.

Please Login or Register  to view this content.

[pareshj]

Hi,

Check the below code and hope it will help you :

Please Login or Register  to view this content.

Regards,
Paresh J