Hide Userform Unless On "Home" page

[RLPeloquin]

Even with this code It still does not always hide Userform1 when I'm on other sheets. Is there another code to absolutely hide Userform1 when I'm not on the "Home" Page

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If ActiveSheet <> ("Home") Then
UserForm1.Hide
End If

 

[My Aswer Is This]

Try this:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
'Modified  5/10/2021  4:07:51 PM  EDT
If ActiveSheet.Name <> "Home" Then UserForm1.Hide
End Sub

 

[My Aswer Is This]

If you want to show the Userform automatically every time you activate sheet named "Home"
But hide it when you activate another sheet try this:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
'Modified  5/10/2021  4:26:51 PM  EDT

Select Case ActiveSheet.Name
    Case "Home"
        UserForm1.Show modeless
Case Else
    UserForm1.Hide
End Select
End Sub

 

[RLPeloquin]

If you want to show the Userform automatically every time you activate sheet named "Home"
But hide it when you activate another sheet try this:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
'Modified  5/10/2021  4:26:51 PM  EDT

Select Case ActiveSheet.Name
    Case "Home"
        UserForm1.Show modeless
Case Else
    UserForm1.Hide
End Select
End Sub

Thanks! Works Perfect

 

[My Aswer Is This]

Thanks! Works Perfect

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.