Windows will send the user a msgbox shortly after

It's Excel. Have a look at the Workbooks.Open method in VBE help,
specifically the Notify argument which controls whether the workbook
available prompt occurs.

--
Jim
"GrantW" wrote in message
...
| In an application that I am creating, one of the macros looks to see if
| another workbook (from which data will be extracted) is Read Only. If it
is
| read only, control is passed to a msgbox advising the user to try again,
then
| the Sub ends. By the time the user clicks ok to the msgbox and tries to
run
| the macro again, the other workbook is usually not Read Only and
everything
| runs as it should.
| However, Windows will send the user a msgbox shortly after, advising that
| the other workbook is now free, and ask if they want to view it. Is there
any
| way to block that Windows advice from being sent?. It is screwing things
up.
| I appreciate any help you can provide.