Yes
Macros are saved as part of a file and then available every time that file is loaded
Macros can be made to occur when special events occur like opening or closing the file, , printing the file, changing sheets or changing cell contents etc
Macros can be stored in special files so that they are available to you in any file you have open. refer: personnel.xlsx
Macros, generally refers to a collection of key strokes or actions which a program records and then is available to you to use to repeat the same combinatiojn of actions.
Programs or subroutines are a smarter version of these as they use VBA (in Excel) which has a whole suite of extras which make the subroutines a lot smarter. These extra controls includes loops and branching, allow you to conditionally control what your subroutine is doing.
To record a Macro click the Little Worksheet Icon with a Red Oreb on it (Lower Left corner of screen).
Make a few changes to your worksheet, add some numbers or change some or delete some cells etc
Stop Recording (the same Icon)
Look at your code Alt F11 and select your Worksheets, Code Module