VBA to Sendkeys or otherwise inhibit Update Values Window
 

2003

What is the best VBA approach to inhibit Update Values Window and/or to
"Sendkeys- Return" the window when it pops up during a VBA procedure?

This occurs when the initiating VBA procedure updates part of a
formula, the other part of which, includes a link to another workbook.
(This occurs even though I selected "Do not Update" during the opening
of the worksheet.

TIA, EagleOne

VBA to Sendkeys or otherwise inhibit Update Values Window
 

Got it! I'm having a DA! day

..DisplayAlerts = False


Dennis wrote:
2003

What is the best VBA approach to inhibit Update Values Window and/or to
"Sendkeys- Return" the window when it pops up during a VBA procedure?

This occurs when the initiating VBA procedure updates part of a
formula, the other part of which, includes a link to another workbook.
(This occurs even though I selected "Do not Update" during the opening
of the worksheet.

TIA, EagleOne