R
Randy
I could use help with the following;
I have a macro and when I run it, it displays a message box offering
three choices, "OK, Cancel and Help". When I choose "OK", the macro
continues to run to a successful conclusion. I want to process this
message box within the micro with the choice "OK". To accomplish
this I use the following code:
Application.DisplayAlerts = OK
When I run the macro initially, the message box still appears even
with this code. I click "OK" and the macro continues sucessfully. If
I run it a second time or subsequent times with the same or different
data, I do not see the message and the macro runs successfully. Only
the initial time the message is displayed.
How do I get the macro to run the initial time without having to
manually process the message box?
Thanks in advance for the help.
Randy
I have a macro and when I run it, it displays a message box offering
three choices, "OK, Cancel and Help". When I choose "OK", the macro
continues to run to a successful conclusion. I want to process this
message box within the micro with the choice "OK". To accomplish
this I use the following code:
Application.DisplayAlerts = OK
When I run the macro initially, the message box still appears even
with this code. I click "OK" and the macro continues sucessfully. If
I run it a second time or subsequent times with the same or different
data, I do not see the message and the macro runs successfully. Only
the initial time the message is displayed.
How do I get the macro to run the initial time without having to
manually process the message box?
Thanks in advance for the help.
Randy