Hi
I have a workbook full of macros. The size jumped from 400 kb to 3.5 mb suddenly. This usually happens because of an error in some code which makes one sheet extraordinarily heavy. I usually delete that sheet and re-create it. However, this time I have tried deleting all the sheets to no effect. I have tried creating a new version and deleting sheets one by one. It is always a new sheet that reduces the size back to normal. When I try to delete the same sheet on my actual workbook, the size doesnt change. I have tried clearing formats as well. Can someone please help?
Bookmarks