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
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