Look at the attachment in #6

Some code (e.g. Workbook_Open) has to go into the ThisWorkbook module and some goes into a standard module

I put in an Intro sheet to make certain that there would always be a visible sheet

Capture.JPG

Capture1.JPG


If you're still stuck, post a SMALL representative sample workbook with sanitized data