Found out what went wrong with the code - I had to add it as a Module in the Normal side of the VBA panel not Project. And it now Works.