Hi.....
I have been battling for hours trying to solve this and I hope someone can please help me

I have a workbook with some hidden worksheets, that open depending on the users choice in a Userform.

The userform is opened when the user clicks a button on the "HOME" Tab, he/she is then presented with two radio buttons, to force a selection of one of two sheets.

Upon selecting the appropriate sheet is activated, unhidden, and the Home tab hidden.

This all seems to work ok, i.e. the sheet required becomes unhidden, and the HOME sheet gets hidden, but when I try and capture information on the sheet displayed, the information that is captured actually appears on the HOME sheet, and NOT the sheet displayed!!

The two option buttons are called obCapture and obPrint

the code below is what I have..........
 
Private Sub CBOk_Click()
    Application.ScreenUpdating = False

          '***** CHECK THAT A SELECTION IS MADE
    
    If Me.obCapture.Value = False And Me.obPrint.Value = False Then
        MsgBox "Please Select Print Form OR Capture!!"
    End If
    
         '***** IF PRINT OPTION IS SELECTED, OPEN PRINT FORM
    
    If Me.obPrint.Value = True Then
        Worksheets("Materials Form").Activate
            ActiveSheet.Visible = True
            Worksheets("Home").Visible = False
        Unload Me
    End If

          '***** IF CAPTURE IS SELECTED, OPEN CAPTURE FORM

    If Me.obCapture.Value = True Then
        Worksheets("Materials Capture").Activate
            ActiveSheet.Visible = True
            Worksheets("Home").Visible = False
        Unload Me
    End If
    
    Application.ScreenUpdating = True
End Sub