Incorporate Unlocking All Sheets Into Macro

[AllDay]

Right now I have a button that refreshes multiple queries over multiple worksheets in the same workbook. These worksheets are all protected and my macro will not update those queries due to the protection.

I added a two additional buttons to unprotect all sheets and protect all sheets.

Can I add those two modules into my original so when I click the original button it would unprotect all sheets, run my VBA, then reprotect all the sheets?

 

[mumps]

If you loop through your sheets to perform certain tasks on each one, you can unprotect/protect each sheet as you go through the loop:

Sub Test()
    Dim ws As Worksheet
    For Each ws In Sheets
        ws.Unprotect
        'your code here
        ws.Protect
    Next ws
End Sub

This would eliminate the need for any buttons or additional macros to protect and unprotect.