HOW TO GET OVER WITH THIS ANNOYING LINKED FILES MSG BOX WHEN I OPEN FILES WHICH HAS LINKS

[CAPTGNVR]

DEAR ALL
I have put the code in VB --Application.AskToUpdateLinks = False--.
Now annoying thing is the message to update the links doest come but
this annoying windows showing the linked files props up. Since I have
four to five persons sheet linked, i have to click cancel four times.
How to handle this pls in VB on worksheet open code.

 

[Mike Fogleman]

Try an Add-In by Bill Manville called FindLink.xla

http://www.oaltd.co.uk/MVP/Default.htm

Mike F

 

[CAPTGNVR]

Try an Add-In by Bill Manville called FindLink.xla

http://www.oaltd.co.uk/MVP/Default.htm

THANK YOU MIKE. I hv checked out the site and downloaded the required
and once again thanks bcos i picked some more like excel utilities exe.