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.