Alright, so I've got a pretty hefty program that is integrating with
excel. My problem is that I'm wanting to avoid a particular dialog
from appearing, just because the portion that it pertains to is
automated. Basically, this has to deal with the .merge function for a
range of cells in excel. It basically asks if I want to continue to
merge the cells since the data from the upper left will be the only
data used. I'm not sure why it asks this, though, considering the
worksheet has no data on it, unless it (for some reason unknown to me)
is trying to apply the changes retrospectively to previously created
worksheets and then overriding that data in my newly created
worksheet.
What I wanna know is how to make it automatically accept those changes.
Jan Hyde (VB MVP) - 19 Oct 2007 13:10 GMT
"levimefford@gmail.com" <levimefford@gmail.com>'s wild
thoughts were released on Wed, 17 Oct 2007 17:35:35 -0000
bearing the following fruit:
>Alright, so I've got a pretty hefty program that is integrating with
>excel. My problem is that I'm wanting to avoid a particular dialog
[quoted text clipped - 9 lines]
>
>What I wanna know is how to make it automatically accept those changes.
Have you tried my previous answer to this question?
--
Jan Hyde
https://mvp.support.microsoft.com/profile/Jan.Hyde