Hi Everyone,
I am not sure what is wrong with these code but workbook does not ask for password when i open. Please see below
Any help will be appreciated
With New_Wkbk
New_Wkbk.SaveAs rCell_Summary.Value & " " & Format(Date, "mmmm yyyy")
Application.DisplayAlerts = False
Set thisWb = ActiveWorkbook
With thisWb
ActiveWorkbook.Protect Password:="SSC", Structure:=True, Windows:=False
ActiveWorkbook.SaveAs fileName:=thisWb.Path
ActiveWorkbook.Close savechanges:=False
End With
Application.DisplayAlerts = True