View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete Davis Pete Davis is offline
external usenet poster
 
Posts: 1
Default Pop up message control using macros

Hi All

Is it possible to respond to pop up messages with a
macro? Im trying to respond to the two following pop ups,
which are generated by activities carried out by the
macro:

1. File already exists. Replace? Yes or No? (Im using the
macro to save an updated version of an existing file). In
this case, I would like the macro to respond with a YES
2. Large amount of data exists on clipboard. Do you want
data to be available.......Yes or No? (Im using the macro
to close a file which ive copied a large amount of data
from.) In this case, I would like the macro to respond
with a NO.

In Macro Record mode, I responded to each message, but no
code of anykind was copied into the macro.

I dont want the user to be inconvenienced with having to
respond to these messages.

Thanks for any advice.

Pete