Re: [ExcelVBA] Stop file link updation box

 

I've not tried this (and have no opportunity to test it)

but you could try adding:

Application.DisplayAlerts = False

to a Workbook_open (or other) macro.

Paul

-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------

On Monday, April 11, 2016 9:09 AM, "Tayyab sheikhtayyab@yahoo.com [ExcelVBA]" <ExcelVBA@yahoogroups.com> wrote:

 

Dear All

I have a set files that linked outside another workbook. When the marco run excel ask to update the link file. how to ignore that message and run complete macro.

thanks

Regards

Tayyab

__._,_.___

---

Posted by: Paul Schreiner <schreiner_paul@att.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___