View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajvasel ajvasel is offline
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