Try checking to see if the userforms are loaded before unhiding.

In the Workbook_Activate event:
If Not Userform1 Is Nothing Then Userform1.Show
If Not Userform2 Is Nothing Then Userform2.Show

This precludes that when the userforms aren't needed then they get
unloaded. This way, the code will unhide the userforms only when
they're loaded.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc