needing to run macro on open BEFORE pompted to update links
Posted by Daniel P. on November 20, 2001 9:51 AM
(Copy of post on November 19, 2001 at 13:20:11, problem stems from vlookup using network files)
I have a workbook (called master) that has cells that are linked to another worksheet (called values) by vlookup.
To avoid network issues, I'm wanting to run a macro on open of "master" that will open the "values" workbook.
I'm not very experienced in VBA. I tried a Workbook_Open macro but the "values" workbook opens after I'm prompted to update the links. Any suggestions?