Save as active workbook with module & macro code in (this workbook)

[nisshaheen76]

Dear all

as the subject i have excel file with macro will attached below, was completed as what we need if sheet tab name with the end of month show message end of month and save as the active workbook with module & macro code in (this workbook) in the new workbook name with new month.
search long time until found vba code to copy all procedure, module and paste in the new workbook
in need the same step but not new workbook want the same of my active workbook with all macro

i hope explain my problem
many thanks for your reply