For some reason, VBA code can inflate file sizes quite dramatically. Excel doesn't reclaim wasted space when you edit code. One solution is to compile the entire project, export all code modules and forms, delete them from the workbook, save, close, open, re-import all modules and code, save.
Messy but it often reduces the size...
Denis