Good evening,
I have a VBA code which works great thanks to members on this forum. I wish to hide the sheet once it is created and am seeking the code to do so. Below is he code I already have. Any assistance will be greatly appreciated. TIA
Tony
VBA Code
I have a VBA code which works great thanks to members on this forum. I wish to hide the sheet once it is created and am seeking the code to do so. Below is he code I already have. Any assistance will be greatly appreciated. TIA
Tony
VBA Code
VBA Code:
Private Sub CommandButton2_Click()
Dim ShtName As String
ShtName = Sheet22.Range("D55").Value
If Evaluate("isref('" & ShtName & "'!A1)") Then
MsgBox "Sheet Already Exists"
Else
Sheet14.Copy , Sheets(Sheets.Count)
ActiveSheet.Name = ShtName
Sheet14.Activate
Range("E9:E36,E38:E46,K9:K25,K38:K52").Value = 0
MsgBox "Sheet Saved Success"
Sheet16.Activate
End If
End Sub