Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating Links in a Protected Sheets
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
links not updating? | Excel Discussion (Misc queries) | |||
updating links | Excel Worksheet Functions | |||
Updating links | Excel Worksheet Functions | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
Module updating of Protected Cells | Excel Discussion (Misc queries) |