Welcome
Press ALT & F11 to open the VBA screen. On the left hand side there should be a screen titled Project-VBAProject.
If this is not visible select view, Project Explorer or CRT R You will see a heading VBAProject followed by your file name in brackets.
Expand this and expand the folder Microsoft Excel Objects. You will see all your sheets and "ThisWorkbook"
Double click on ThisWorkbook it will open a screen to place your code. Or right click and select view code
This is where you need to place the macro suggested. It is a workbook event macro.
There are two drop down boxes at the top of this screen. Select the first one and it will show the options (general) and Workbook. Select Workbook. In the second dropdown box you will see a list of events that you can add code to make things happen.
Each sheet also has similar dropdown boxes of events that can be coded.
Next select insert, Module this will create a blank module where you will place the macros you write or macros that you record using the macro recorder.
Best advice I can give you is Play the recorder it is a great learning tool. Read the help files, and use the object browser it is one of the buttons on your VBA toolbar. search the archives here for help there is tons of knowledge if you look for it. And keep posting if you are stuck