LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Auto Update files for just this run of code

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.)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto update excel files tqah Excel Discussion (Misc queries) 1 January 22nd 10 01:24 PM
Refernce other files and auto update info Riptide Excel Discussion (Misc queries) 1 January 13th 10 09:23 PM
Code to auto update a footer Valerie M Excel Programming 2 December 3rd 07 11:06 PM
Update Code to work between 2 files dkenebre[_6_] Excel Programming 4 August 12th 05 03:34 PM
how to update data on sheet1 and have it auto update on sheet2 Tommy Excel Programming 6 May 11th 05 06:41 PM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"