Reducing Excel Macro-Enabled File Size - Hack discovered

[Oncemessages]

I discovered this hack to reduce excel file size. I have made many code changes (I am over 60k lines of code), and every time I make a change, even if data is not added, and in fact sheets are removed or userforms removed, the excel file keeps creeping up in size. As long as there are some VBA changes, the file size will increase.

However, there is a hack that will reduce it to the "real" size. Simply open the workbook, open up a userform without making changes and then exit. Excel will prompt you to save, and when you do so, the file size decreases.

Thank everyone ! - Apkafe