I have a workbook that has links to 6 different workbooks. I want to have 5
of the 6 updated. I've done the "do not update" under edit=links, but this
disables all of the links. How can I just disable one (or disable them all
there and in VBA enable the other 5)?

Thanks!!!

Let me rephrase the question:

I would like to write VB code to update only one of the links when the
workbook is opened. Is there a way to do this? If there is, how do I do it?

Thanks!

"ChrisP" wrote:

I have a workbook that has links to 6 different workbooks. I want to have 5
of the 6 updated. I've done the "do not update" under edit=links, but this
disables all of the links. How can I just disable one (or disable them all
there and in VBA enable the other 5)?

Thanks!!!