Hi Leo,

Welcome to ExcelFox !!!

Place the Workbook_Open code in the Workbook module. Place other two subs in a standard module.

HTH