One thing that might be confusing you is that you can add VBA to VB
modules (by clicking on Insert-Module in the VBE) *OR* you can add
VBA to worksheets (expand Excel Objects in the VBE and double click
the Sheet).


You might imagine that you're losing macros when you're actually been
adding VBA to a Worksheet and you just don't see when you exit and
return to the VBE.