Workbook_open procedure issue when two spreadsheets are opened

[Gardfd]

I have a spreadsheet that launches a splashscreen when opened, after
specified time, the splashscreen closes and launches a form requiring user
level selection and password requirements. All works fine when this is the
only spreadsheet being opened, lets call it spreadsheet 1.

The issue is when a second spreadsheet is being opened at the same time, I
get a script error. I think the issue is because the second spreadsheet,
lets call it spreadsheet 2, is now the active workbook and the code of course
is not applicable to spreadsheet 2.

Any thoughts how to get around this,

Thanks

 

[Doug Glancy]

Try using ThisWorkbook instead of Activeworkbook?

hth,

Doug

 

[Tom Ogilvy]

Use ThisWorkbook rather than ActiveWorkbook in your references.