I have this macro that clears the entire workbook. Essentially, I want to have the workbook or a copy of the workbook be saved under whatever path and file name the user chooses to save the file under before the original has cleared out. I am calling a macro that does this under the clear macro, but it requires the original to close so the rest of the macro doesnt run and nothing is cleared out on the original. Is there a way to do this?
The save as new file macro that I am calling is below for reference.
Bookmarks