My below sub copies data to a sheet that is now protected
The PW is "football"
My copy is now debugging, how can i code in the pw?
'When the targets have been uploaded to CV, the admin will use this button to clear out uploaded amendments/additions
Application.ScreenUpdating = False
Dim Lastrow As Integer
Sheets("Change Summary").Range(Range("A2"), Range("L" & Rows.Count).End(xlUp)).Copy _
Sheets("Log").Range("A" & Rows.Count).End(xlUp).Offset(1)
Lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
Range("A2:L2" & Lastrow).ClearContents
Application.ScreenUpdating = True