It is UserForm2 in the Project Explorer and has 7 command buttons for manipulating the data in various ways on the particular worksheet. When I load it, the form appears on screen no matter which worksheet I am viewing.
You need to use a worksheet change event in that case
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name <> "YourSheetGoesHere" And UserForm2.Visible = True Then
If Sh.Name = "YourSheetGoesHere" And Userform2.Visible = False Then
So if the sheet that is being made active is not equal to the sheet you want, and the form is actually loaded and visible, then unload that form. Otherwise, leave it alone.