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

Update Values Dialog
 

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