Using Retry/Cancel MsgBox

[Yeoman.jeremy]

hi there.
I've written a macro, which requires opening a certain workbook then closing it again. I want this macro to only work if the file is closed to start with.

I know how to make an 'ok only' messagebox, but how do i use the retry/cancel, so that if there is an error with opening the file (i.e if it is already open) it runs the retry/cancel?
I want the retry to check if it can open the file again, and the cancel to stop the macro without showing the "debug, end" msgbox etc


help would be much appreciated

 

[RoryA]

Can you not simply use the workbook if it's already open? Why the need to close and reopen?

 

[Yeoman.jeremy]

The intention is that this other separate workbook shouldn't be constantly open anyway. It needs to be able to be opened and edited from other computers on the network at the same time, and if it's currently open it can only be used by other computers in read only mode.

Basically the messagebox just needs to be there to try remind staff that they shouldn't be leaving it open anyway