Steve Jukes
Board Regular
- Joined
- Apr 15, 2002
- Messages
- 83
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
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