Look a few lines up from there. See where it says "ThisWorkbook" just below "Sheet5 (Drop Downs)" and just above "Modules"?
Cut the code from Module 5, double click where it says "ThisWorkbook" and paste it in there. That way it will fire whenever you open the workbook.

BSB