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

Out of resources error message - when not... 3
VBA to center Selected Cell in Current Window 1
Avoid Update Values Prompts 6
Display value of a VBA variable inside a cell 2
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value) , 2
Cell updates not occuring 13
Problem sorting a range of columns using VBA 1
Deleting Code from a Worksheet is Locking Up 5

Top