Macro to Unprotect, Run a Sort, Then Re-protect... Please

[Tricky]

I have a sheet with data C3:N127. It is a named range: masterlist. Above the column headers, I have placed 10 arrows and have assigned sort macros to them. Such as:

Sub MacroJobName()
'
' 1/24/2015 by Ricky's 7
'
    Range("masterlist").Sort Key1:=Range("i3"), Order1:=xlAscending, Key2:=Range("C3") _
        , Order2:=xlAscending, Header:=xlNo, OrderCustom:=1, MatchCase:=False, _
        Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:= _
        xlSortNormal
End Sub

The cells in the data sheet are locked, as the data is retrieved from other places, and the sheet is protected. Because the cells are locked, sorting is not allowed. I need help with code to unprotect the sheet, then call up a sort macro, then re-protect the sheet. Or, I could just add the on/off protection code to each of the ten sort macros. Suggestions certainly welcome.

Thanks,
Ricky

 

[Tricky]

Okay...

This wasn't as complicated as I first imagined, although there still may be a "cleaner" way to do this...

I added this line to the beginning of each Sort Macro that I had. This unprotects the sheet so the sort code can run. Even if the sheets were renamed, they still retain their original "Sheet#" name for coding purposes.

Sheet1.Unprotect Password:="***************"

Then, added: Sheet1.Protect Password:="***************" to the end of the code just prior to the End Sub line. This re-protects the sheet with your defined password.