Need Macro to Protect worksheets that haven't been created yet

[taj2012]

I have a Macro in place that automatically creates a duplicate of a worksheet. When I create a duplicate, the worksheet protection settings go away. Is there a Macro that would automatically protect a newly created worksheet without manually protecting it?

 

[Damon Ostrander]

Add this code to your workbook's ThisWorkbook code module:

Private Sub Workbook_NewSheet(ByVal Sh as Object) 
 Sh.Password = "mysheetpassword"    'put your password here
End Sub