Update Values Dialog

Hi,

I used Find and Replace to formulas which referenced to another
workbook. For each formula I was prompted to the workbook which was
renamed and this is quite annoying. Is it possible to write a find
replace vba code with a single prompt to the renamed workbook?

TIA,
Agustus

look in Excel VBA help at the ChangeLink method.

--
Regards,
Tom Ogilvy


"Agustus" wrote:

> Hi,
>
> I used Find and Replace to formulas which referenced to another
> workbook. For each formula I was prompted to the workbook which was
> renamed and this is quite annoying. Is it possible to write a find
> replace vba code with a single prompt to the renamed workbook?
>
> TIA,
> Agustus
>
>