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: 26
Default SendKeys Positioning

I am trying to make a program that I have created as user-friendly as
possible. During the program, I delete 2 worksheets to leave only 1
worksheet. I tried using a SendKeys statement to click through the
confirmation pop-up message, but I think that I may be placing the statement
in the wrong area.

Here is the statement I used:

Application.SendKeys ("{Enter}")

Where should I place this in the program, or is there a way to delete sheets
without a pop-up message displaying? Thx
 
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
Positioning Roger[_20_] Excel Programming 4 July 8th 05 08:54 PM
SendKeys in VBA John Excel Programming 1 June 24th 05 05:46 PM
Sendkeys Jim Excel Programming 1 April 16th 05 06:44 PM
= positioning snax500[_2_] Excel Programming 1 June 28th 04 08:24 PM
Sendkeys GB[_3_] Excel Programming 0 September 16th 03 10:39 PM


All times are GMT +1. The time now is 01:56 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"