LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
window with update value pol Excel Discussion (Misc queries) 2 May 21st 09 12:24 PM
Excel charts do not update when using SendKeys nandan Charts and Charting in Excel 8 April 9th 07 06:14 PM
inhibit input Pastel Hughes Excel Discussion (Misc queries) 1 April 24th 06 09:13 PM
Inhibit Cut (allow Copy) duncan Excel Programming 3 March 29th 05 09:00 AM
Problem with SendKeys + active window Roadie Excel Programming 4 April 26th 04 04:07 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"