thousand
New member
- Joined
- Apr 2, 2017
- Messages
- 30
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
Hi
I have a basic code which activates the userform but I am wanting to add a copy function in the form, is this possible by adjusting the existing code below
Thanks in advance
Private Sub Workbook_NewSheet(ByVal Sh As Object)
If ActiveSheet.Name <> "Sheet1" Then
ActiveSheet.ShowDataForm
End If
End Sub
I have a basic code which activates the userform but I am wanting to add a copy function in the form, is this possible by adjusting the existing code below
Thanks in advance
Private Sub Workbook_NewSheet(ByVal Sh As Object)
If ActiveSheet.Name <> "Sheet1" Then
ActiveSheet.ShowDataForm
End If
End Sub