Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent Excel from popping-up an "OK" (information) message
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!) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent Excel from popping-up an "OK" (information) message
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 -- HTH... Jim Thomlinson "crimsonkng" wrote: 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!) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent Excel from popping-up an "OK" (information) message
Thanks, Jim. Yer a pal.
Dan "Jim Thomlinson" wrote: 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 -- HTH... Jim Thomlinson "crimsonkng" wrote: 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!) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
prevent Excel from popping-up an "OK" (information) message
You can try the following code before start the procedu 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 -- lgarci ----------------------------------------------------------------------- lgarcia's Profile: http://www.excelforum.com/member.php...nfo&userid=952 View this thread: http://www.excelforum.com/showthread.php?threadid=48025 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
Stop the "Personal" sheet from popping up every time I open a work | Excel Discussion (Misc queries) | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
"Cannot empty clipboard" message keeps popping up | Excel Discussion (Misc queries) | |||
Prevent "XYZ.doc is locked for editing" message | Excel Programming |