|
-
Apr 14th, 2006, 10:32 AM
#1
Thread Starter
Addicted Member
Disabling External Links Dialog Box
Does anybody know how to do this?
Through VB, I create an instance of Excel. Then, I set the display alerts, interactive, and screenupdating properties to false.
Then, I loop through my workbooks and do my processing.
I'm trying to write this so it can run 100% automated (Unattended Execution).
When my program comes across a workbook that has external links to other Excel Workbooks, that dialog box still comes up asking the user if they want to update the data from external links. I want to turn this feature off so my program keeps running by itself.
Any help on this would be greatly appreciated...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|