cocopops2001
Board Regular
- Joined
- Apr 18, 2011
- Messages
- 112
I have a workbook which makes use of a folder picker and a text input box to create new workbooks.
the folder picker works well and so does the input box if the process is followed as it should be.
my problem is that when the procedures, pick folder, pick name or both are cancelled or closed the macro still runs but i dont want it to.
all i need is a bit of code that says if either the cancel button or the close 'X' button is pressed on either the macro aborts.
thanks
the folder picker works well and so does the input box if the process is followed as it should be.
my problem is that when the procedures, pick folder, pick name or both are cancelled or closed the macro still runs but i dont want it to.
all i need is a bit of code that says if either the cancel button or the close 'X' button is pressed on either the macro aborts.
thanks