make user form stay open while going to other pages but hide when i go to other sheet

Hi,

I have a user form for one sheet, and I want it to stay on the screen, but want it to leave when I go to other screens.
How do I go about doing this?
This is what I have so far and it just stays on the screen as I go from sheet to sheet.

Sub Show_Userform()
UserForm1.Show vbModeless
End Sub

Thanks