Can I Duplicate a sheet/new name for sheet/hide certian columns with a userform?

[DeezNuts]

I am trying to duplicate a sheet give the new sheet a unique name and hide certain ranges of columns using a userform. I explain it this video

https://www.youtube.com/watch?v=SB-deV3uzWA would have used the insert video option but it doesnt work

here is the sample file https://www.dropbox.com/s/td3vb1sqwa...Idea.xlsm?dl=0

Thank you

 

[DeezNuts]

Well if anyone was paying attention or cared about this post here is what I did and seems to work out

Private Sub shtCreate_Click()
  
 Sheets("MasterSheet").Visible = True
 Worksheets("MasterSheet").Copy After:=Worksheets(Sheets.Count)
 ActiveSheet.Name = TextBox1.Value
 
 If SelCourse1.Value = "Weighted" Then
 Columns("A:F").EntireColumn.Hidden = True
 Else:
 Columns("F:K").EntireColumn.Hidden = True
 End If
 If SelCourse2.Value = "Weighted" Then
 Columns("M:R").EntireColumn.Hidden = True
 Else:
 Columns("R:W").EntireColumn.Hidden = True
 End If
 If SelCourse3.Value = "Weighted" Then
 Columns("Y:AD").EntireColumn.Hidden = True
 Else:
 Columns("AD:AI").EntireColumn.Hidden = True
 End If
 Sheets("MasterSheet").Visible = False
    Unload Me
End Sub

 

[mrmmickle1]

DeezNuts,

Thanks for the resolution. I was interested in the subject matter for this thread.