MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Re: Automatic links message - HUH?

Posted by John on November 15, 2001 7:01 AM

Juan Pablo,

I tried "Application.DisplayAlerts = False" and that did not work. I don't understand what you mean with your first solution.



Posted by Juan Pablo on November 15, 2001 8:06 AM

I thought you mean opening *another* book with a macro, i think what you want to do is open just one book that has links, right ? (By the way, didn't need to repost, i had already seen it)

If so, i think the only solution is to change the Options (Data, options), in the Calculate page, uncheck "update remote references"

Juan Pablo ,

Posted by John on November 15, 2001 1:10 PM

No, I'm opening an excel file and the message appears about automatic links. I want the user to be able to go directly to work without worrying about any messages or open file pop-ups.