Problem with Linked Sheets

[devGarfield]

Hi,

I am creating a new workbook with 3 sheets which have been copied from another workbook. When I open the new workbook it asks to update the links for the formula's, Is there a way using VBA to prevent this from happening? so that it uses the sheets that are in the new workbook only?

Garfield

 

[TonyJollans]

Hi devGarfield,

If you have 2000 or later, you can Select Edit > Links... from the menu, Press Change Source and choose the new workbook; all links should then refer within itself only.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[devGarfield]

Thanks Tony

That worked a treat, I ran a macro and added the code to my procedure.

Thanks
Garfield