Application.EnableEvents = False
Workbooks(change).Activate
Application.EnableEvents = True

might work better in both cases.

--
Regards,
Tom Ogilvy

"rammieib" wrote in message
ups.com...
In my code, when I open up a new workbook which has a userform splash
screen, the unload userform1 code works tos top it loading up.

However, later on in the coding where I activate to a different
workbook, the unload userform1 doesn't stop the userform from
appearing? Code below.

Workbooks(change).Activate
Unload UserForm1

Any ideas?