Right-click on the title bar of the workbook and choose View Code.
paste the macro into the ThisWorkbook code module which opens.

In article ,
(Timothy) wrote:

Thanks for the Reply, however where do I put the code, I'm having
trouble finding the Activate Event Location for my workbook.