I'm trying to, I suppose for want of a better description, paste a
WorbookOpen sub-routine into 'ThisWorkbook' component of a project in a
new workbook.

Basically I use shell files that refresh data from Access/Oracle
tables, add any necessary formatting, then copy an array of sheets to a
new workbook. I have since created some additional code that allows me
to track who opens these final reports and the frequency.

I have no trouble importing my .bas file, however adding the code to
ThisWorkbook to call the sub-routine on WorkbookOpen is causing issues.

Can anyone assist?

MT