Sub SAVE_REPORT()
Dim Path1 As String, ws As Worksheet
Path1 = "C:\DEV\REPORT FOLDER" & "\" & "REPORT" & Format(Now, " dd-mm-yyyy ")
ActiveSheet.Unprotect Password:="report"
Sheets("1").Unprotect Password:="report"
Sheets("2").Unprotect Password:="report"
Sheets("3").Unprotect Password:="report"
Sheets("4").Unprotect Password:="report"
Sheets(Array("SUMMARY", "1", "2", "3", "4")).Copy
For Each ws In ActiveWorkbook.Worksheets
ws.UsedRange.Value = ws.UsedRange.Value
Next ws
ActiveWorkbook.SaveAs Filename:=Path1, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Application.CopyObjectsWithCells = False
ActiveWindow.Close
ActiveSheet.Protect DrawingObjects:=True, _
Contents:=True, Scenarios:=True, Password:="report"
Sheets("1").Protect DrawingObjects:=True, _
Contents:=True, Scenarios:=True, Password:="report"
Sheets("2").Protect DrawingObjects:=True, _
Contents:=True, Scenarios:=True, Password:="report"
Sheets("3").Protect DrawingObjects:=True, _
Contents:=True, Scenarios:=True, Password:="report"
Sheets("4").Protect DrawingObjects:=True, _
Contents:=True, Scenarios:=True, Password:="report"
End Sub
Bookmarks