Dear Learned people
I have a macro that, when it has run through all the code saves the workbook with a different name using "Save As" .
I added a command button "Save & New" on a user-form in a certain position in the code.
I would like for the user to save the workbook (Save As) and then have the macro to run from the beginning when the cmd button is clicked.
you help will be appreciated, as always.
kind regards
Andy
I have a macro that, when it has run through all the code saves the workbook with a different name using "Save As" .
I added a command button "Save & New" on a user-form in a certain position in the code.
I would like for the user to save the workbook (Save As) and then have the macro to run from the beginning when the cmd button is clicked.
you help will be appreciated, as always.
kind regards
Andy