I have a Master workbook that needs to be renamed before use so that the
master remains blank of data and ready for the next event. I need a way to
pause the macro and let the user enter a new name, hit save and the macro
continue. Currently when I try to record, I hit file/save-as and the save
window opens, awaiting input, I then cannot pause or stop recording as it
blips me as there is no input. I don't want to have the new name inserted as
it will change every 6 months.
I would be satisfied with the macro stopping after the save-as window is
opened so the user could input a new name and manually save it.
Please be specific on where to place the code as I am an intermediate on
macro's and worse on VBA. I do know how to step into it, but very
unknowledgeable on editing the code.
thanks