From: Dave Peterson on
I don't understand.

You said it works, but now it sounds like you still see the message.

Bob Barnes wrote:
>
> Dave - Not sure why the "warning" appears, but the data I need
> is there from the automation code in Access.
>
> Thanks again - Bob
>
> "Dave Peterson" wrote:
>
> > Nope.
> >
> > This doesn't even see the warning box--it just assumes that you don't want to be
> > bothered by the warning and that you know what you're doing.
> >
> > Bob Barnes wrote:
> > >
> > > That works..Thank you.
> > >
> > > Only question. Since the Focus is set to "Yes"...that should answer as "Yes".
> > >
> > > Thanks again - Bob
> > >
> > > "Dave Peterson" wrote:
> > >
> > > > Sometimes, this'll work:
> > > >
> > > > Application.displayalerts = false
> > > > 'your code that causes the alert to appear
> > > > application.displayalerts = true
> > > >
> > > >
> > > >
> > > > Bob Barnes wrote:
> > > > >
> > > > > Gord - Thank you.
> > > > >
> > > > > I'm not sure what is causing...
> > > > > Your Auto_Open code is obviously trying to paste something into filled cells
> > > > > or
> > > > > similar operation like Text to Columns.
> > > > >
> > > > > Your..
> > > > > You can turn off the message and have it default to "Yes" but are you sure you
> > > > > want the destination cells to be replaced?
> > > > >
> > > > > Bob --> Yes, I'd like to turnoff the MsgBox and default to Yes replacing
> > > > > destination cells...How do I do that? Everything is being populated via
> > > > > automation from Access...and is doing what is needed.
> > > > >
> > > > > TIA - Bob
> > > > >
> > > > > "Gord Dibben" wrote:
> > > > >
> > > > > > Your Auto_Open code is obviously trying to paste something into filled cells or
> > > > > > similar operation like Text to Columns.
> > > > > >
> > > > > > You can turn off the message and have it default to "Yes" but are you sure you
> > > > > > want the destination cells to be replaced?
> > > > > >
> > > > > > Check your code to see what it is doing before adding more code to turn off the
> > > > > > message.
> > > > > >
> > > > > >
> > > > > > Gord Dibben MS Excel MVP
> > > > > >
> > > > > >
> > > > > > On Mon, 15 Jan 2007 11:02:01 -0800, Bob Barnes
> > > > > > <BobBarnes(a)discussions.microsoft.com> wrote:
> > > > > >
> > > > > > >I have an AUTO_OPEN macro...
> > > > > > >
> > > > > > >Sometimes, I get the Message Above w/ Yes and No Buttons.
> > > > > > >
> > > > > > >Why does this occur...can I turn it off?
> > > > > > >
> > > > > > >TIA - Bob
> > > > > >
> > > > > >
> > > >
> > > > --
> > > >
> > > > Dave Peterson
> > > >
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson