disable warning AND actions

[DiGiMac]

I have a macro that merges selected cells. If they contain text it gives the user the choice of combining all the separate texts as a single string in the merged cell.
The macro works but the default warning always gets pops up first to advise me that only the top left text will be kept. If I click "cancel" then my form comes up.
"Application.DisplayAlerts = False" hides the warning but assumes "OK" so the cells are merged maintaining only the top left text.
How can I block the warning AND the default action?

 

[ChrisM]

Not quite following the problem you are stating at the end, but how about this:

1. Read all the text from the cells into a string array or two string variables if that would work.

2. Clear the cell values

3. Ask the user how to handle the various text pieces

4. Merge the cells

5. Write the final text

This way, since you've deleted the values before merging, Excel won't give you any warnings at all.

 

[DiGiMac]

Duh, did I mention that I'm an idiot?
I didn't? Well I have now.
As is often the case, all it takes is a fresh pair of eyes and they see the solution was there in front of you the whole time.
Thanks ChrisM