I am currently trying to adjust a macro so that it unprotects multiple worksheets at the begining and protects them at the end.
So for example I would like the macro to unprotect sheet1, sheet2, sheet3 and sheet4 and once finished it re-applies the protection.


I know using the following code will unprotect and protect the active sheet;
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
        , AllowFiltering:=True
    ActiveSheet.Unprotect
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
        , AllowFiltering:=True
Any help that you can provide would be appreciated

Regards

Paul Moss