Thread: "Do you want to replace the contents of the destination cells?"
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default "Do you want to replace the contents of the destination cells?"
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

Reply With QuoteReply With Quote