Inserting Macros

Open the Visual Basic Editor
Find the Personal.xlsb project
Expand the Modules folder

The Visual Basic for Applications window will be opened automatically.
You will see that a code module has been added to the active workbook and that the following code has been added:
You are now ready to insert or paste in you own VBA code.
Once you have entered your VBA code select (Debug > Compile) to make sure your code does not contain any syntax errors.
After you have finished you can return to Excel by selecting (File > Close and Return to Microsoft Excel).

You can quickly display the Visual Basic Editor by clicking Edit in the Macros dialog box

The project explorer lists any workbooks you have currently got open and also includes any workbooks in the xlStart folder or alternate startup folder. Even workbooks that are hidden (ie the Personal.xls).