Saving

When you record a new macro there are a couple of places you can store it. These will depend on the Microsoft Office application you are using.
This is a common question and there is not really one answer that fits all situations.
An important factor though is whether you want anyone else to have access to your macros.

Excel - Personal.xlsm

For more details about the Personal.xls workbook, refer to the Excel > Macros > Personal.xlsb page.
If the functionality is to be shared by several users, you should consider creating an Excel Add-in.

Excel - Add-in.xlam

Excel add-ins can be either .xla or xll
A VBA add-in is a file which can provide additional functionality to a Microsoft Office application.
You should always recompile your code before saving your file as an add-in.
These are ideal for distributing custom worksheet functions.
For details about how to create Excel add-ins refer to Excel > Add-ins.
For more details about how to install an Excel add-in, refer to the Excel > Add-ins > Installing page.
For more details about how to remove an Excel add-in, refer to the Excel > Add-ins > Removing page.
For more details about how to remove an Excel add-in, refer to the Excel > Add-ins > Replacing page.

Word - Normal.dotm

For more details about the Normal template, please refer to the Word > Templates > Normal.dotm page under Word.
If the functionality is to be shared by several users, you should consider creating a Word Add-in or using a Global Template.

Word - Add-in.dotm

Word add-ins can be either .dot or wll.
For more details about how to install an Word add-in, refer to the Word > Add-ins > Installing page.

PowerPoint - Add-in.potm

For more details about how to install an PowerPoint add-in, refer to the [[PowerPoint > Add-ins > Installing]] page.

Outlook - VBAProject.otm