It depends. I recently wrote a macro to open all files in a folder and
delete a procedure in a worksheet_change event and insert a new one save
and close the file.
Details?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gustaf" wrote in message
...
Hi all,

I got a large number of Excel files, all with a reference (in the VBA
editor) to another file. I wonder if it's possible to programmatically
change the reference in all files, to save the repetitive work of changing
each manually?

Gustaf