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

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.