help with code to create a new sheet each quarter

You had a typo, and you need to use SaveCopyAs instead of SaveAs, and it is better to not have .xlsm in the name string other than as the extension.

Please Login or Register  to view this content.

I think that you have the logic backwards - the code is keeping all tabs in the file with the date in its name, and deleting all but the Menu sheet from the file with the original name. At least that is how it works for me... I did not change the logic, just the code to not get errors.

I don't know what to tell you except that is what I think it does - a copy of the original workbook is saved with a date stamp in its name, and then all sheets but Menu are deleted, and the original workbook is saved as a one-sheet workbook. If you post an original workbook, a date-stamped version of the workbook, and the post-macro version of the original workbook, then maybe....

That's because the code is not designed to run in the workbook open event. You will never be able to open the copy or the workbook - but you will get more and more files created. You need to have a way out of the code if it has already run or is running in a copy of the workbook. So run it manually, as it was designed.