Hello everyone,
In the following macro I would like to add a script instead of "'do nothing" for the Sheets HSheet and SS. How do I do this please? For instance I want to clear contents in range C3 to G3 of those two sheets.
Thanks and much appreciation.
In the following macro I would like to add a script instead of "'do nothing" for the Sheets HSheet and SS. How do I do this please? For instance I want to clear contents in range C3 to G3 of those two sheets.
VBA Code:
For i = 1 To ans2
Select Case Sheets(i).Name
Case "HSheet", "SS"
'do nothing
Case Else
Sheets(i).Unprotect "mypassword"
End Select
Next
Thanks and much appreciation.