Have you tried to debug your code to see if it is being called at all? VBA: How to Debug Code - Overview, Tools, Shortcut Keys | Wall Street Oasis