PC Review


Reply
Thread Tools Rate Thread

Auto Update files for just this run of code

 
 
BlueWolvering
Guest
Posts: n/a
 
      5th Feb 2008
Hello,
I have VBA code that, for a number of reasons, copies a tab into a workbook,
then that same workbook back as a tab in the master.

My problem is the darn "Would you like to update the linked data?" message
box pops up for each tab copied in this way.

I do NOT want to set it to always update through links in the edit menu,
because for anyone else running this, it should NOT update, but during this
piece of code it should.

Any ideas?

(application.displayalerts = false does NOT hide this message box, btw.)
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to auto update a footer Valerie M Microsoft Excel Programming 2 3rd Dec 2007 11:06 PM
Form code auto update fields =?Utf-8?B?UGhpbA==?= Microsoft Access Form Coding 2 6th Sep 2005 02:00 PM
Date field code will not auto update =?Utf-8?B?TU9UbWFu?= Microsoft Word Document Management 1 18th Jun 2005 12:11 PM
auto update error code (0x800C0005) frustrated Microsoft Windows 2000 Windows Updates 0 29th Jul 2004 04:21 PM
Auto update files james Microsoft Windows 2000 Windows Updates 1 31st Jan 2004 03:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:32 AM.