Hi all,
I have code that will run through all the open spreadsheets and make a check on them. When a sheet Fails i want the code to pause while the operator has change to close, save & close the spreadsheet or to make amendments.
I would like to resume the code from where it paused through the means of pressing a simple button in a message box or a form.
Should you need any more information please let me know.
Thank you
cg084.
I have code that will run through all the open spreadsheets and make a check on them. When a sheet Fails i want the code to pause while the operator has change to close, save & close the spreadsheet or to make amendments.
I would like to resume the code from where it paused through the means of pressing a simple button in a message box or a form.
Should you need any more information please let me know.
Thank you
cg084.