Hi, this came to me at the last minute as an idea.
I want (the macro works perfectly) and it saves absolutely everything - all worksheets, macros, etc.
If in the workbook I have 12 worksheets and I work in worksheet 3, just take the information that is written in it and again save the whole workbook, if I work in worksheet for example 11, take the information from said cells and save the entire workbook again.
Just like SaveAs.....
I don't want to save only the specific worksheet, but the whole excel file
Thank you very much!