In the VBA development environment (Alt+F11), at the left you see the
Project Explorer. The first macro is an event macro to detect
workbook-level events. It should be pasted to the module that opens
when you double-click the ThisWorkbook object.

For a regular code module, use Insert|Module. It will create a
"regular" code module called Module1 and open it. Paste the code in
there.

HTH
Kostis Vezerides