View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dennis Dennis is offline
external usenet poster
 
Posts: 59
Default 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