Updating Links in a Protected Sheets
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 |
Updating Links in a Protected Sheets
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 " wrote: 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 |
Updating Links in a Protected Sheets
|
All times are GMT +1. The time now is 02:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com