prevent Excel from popping-up an "OK" (information) message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My macro merges various cells (A1 thru K1) at various times. A1 thru E1 are
already merged as one cell but I want to merge them with cells F1:K1. But
when my macro does that, Excel displays this message (and requires that the
User hit "OK"):
"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

I don't want the User to have to hit "OK" every time that the macro merges
the cells (which happens about 20 times) ... how do I tell Excel to
automatically perform the merge without popping-up that message?

Dan

(BTW ... I love this Excel Discussion Group ... you people are SO smart!)
 
You need to toggle the display alerts setting. Any time you play with these
settings you are best to use an error handler to take care of the inevitable
crashes (something will go wrong eventually so you may as well deal with it
before it happens)

sub DoMyStuff()
On Error Goto ErrorHandler
application.displayalerts = false
'Merge like there was no tomorrow

ErrorHandler:
application.displayalerts = true
end sub
 
Thanks, Jim. Yer a pal.
Dan

Jim Thomlinson said:
You need to toggle the display alerts setting. Any time you play with these
settings you are best to use an error handler to take care of the inevitable
crashes (something will go wrong eventually so you may as well deal with it
before it happens)

sub DoMyStuff()
On Error Goto ErrorHandler
application.displayalerts = false
'Merge like there was no tomorrow

ErrorHandler:
application.displayalerts = true
end sub
Click to expand...
 
You can try the following code before start the procedure:

Application.ScreenUpdating = false

Do not forget to set it true after finished!

If it does not work, try the "send keys":

send keys "{ENTER}", TRUE

Regards
 
Back
Top