I have a workbook with two sheets that are both protected. One of my macros
on the second sheet updates links to two other workbooks. When I try to run
this macro it won't work while the sheets are protected. I first tried
unlocking the cells in my worksheet that are linked to other workbooks and
that didn't work. The only solution I've found is to unprotect both sheets,
run the macro, and then re-protect them. Is there an easier way?

Thanks

Adam Bush