Is file or workbook already open

[Steve Jukes]

I have a workbook that loads a form and from this formn there are optionbuttons set thaif you click them they will open a specific file.
The problem is when you re-click on these optionbuttons the message 'Do you want to re-open file. Re-opening file will.......'. It used to end the code but I have managed to put an 'onerror' command in VBA stopping the breaking of code but it still comes up with this message. Could you please tell me how to stop this message coming up or if there is another way of detecting if the file is already open and therefore only activating the workbook.

Many thanks
Steve

 

[Al Chara]

Application.displayalerts=false

...will make sure no pop-up messages are shown.

 

[Al Chara]

Or to answer your second question, you can try the following:

On Error GoTo errorhandler
Windows("Book2.xls").Activate
Exit Sub
errorhandler:
Workbooks.Open "Book2.xls"

Put this code where you have your buttons.