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