Updating Links in a Protected Sheets

[Guest]

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

 

[Guest]

add in the macro a step which unprotects the sheet and then reprotects the
sheet.
I would be carefull so that others can not just look at the macro to see
your password

 

[Dave Peterson]

I don't think so.

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