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