Auto Update files for just this run of code

B

BlueWolvering

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top