You can see that in excel  as well, although the modules  are stored with
each excel workbook, unless you create a personal workbook  which will
act like an add-in and allow you to run your code against any loaded
spreadsheet.

Inside the VBE - select View, Project Window & I also like the
Properties Window to be displayed.

See www.personal-computer-tutor.com/personalxls.htm for help on
creating a Personal Macro Library for yourself. (I store my
Personal.xls file on the network to get backed up, and store a shortcut
to it in my XLStart folder so it opens and is available for use.)