VBA to Sendkeys or otherwise inhibit Update Values Window

D

Dennis

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
 

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

Similar Threads

VBA to center Selected Cell in Current Window 0
How to control the Excel VBA Editor Main Window Caption 6
"Add to Selection" , SendKeys, Delete Nth Row 3
What is fastest for this? Small VBA or many worksheet formulas...? 1
insert/names/apply - how to "select all" ? 1
Use VBA to get values from named range that contains an array formulaexpression 3
VBA solution to paste text into megred cells 7
Data Update Loops between Folders 2

Top