Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Batch Processing Macro | Excel Programming | |||
Processing...Please Wait Message Box | Excel Discussion (Misc queries) | |||
Macro for Row Processing | Excel Programming | |||
Display message: Processing.... | Excel Programming | |||
processing message | Excel Programming |