I got a new hard drive and completely reinstalled Windows and Office 2003 and ever since then macros disappear randomly from workbooks. Sometimes they're gone forever and sometimes they come back after you open other workbooks. Before that I'd never seen this happen in 15 years.

Online someone said to go to Window > Unhide > choose personal.xls which helped for a few days and now the macros all vanished again. Anyway that meant personal.xls had to always stay open which was irritating and it never used to be like that.

PS in case you're thinking of telling me to use a newer version: don't waste your time. Hundreds of people have told me for 10+ years to upgrade and they all failed and you will too. This is non-negotiable. I repeat, you're wasting your time. 2003 is completely perfect for my needs.