"Do you want to replace the contents of the destination cells?
in [General]
|
From: Bob Barnes on 15 Jan 2007 15:05 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 > >
From: Dave Peterson on 15 Jan 2007 15:55 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
From: Bob Barnes on 15 Jan 2007 16:33 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 >
From: Dave Peterson on 15 Jan 2007 17:28 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
From: Bob Barnes on 15 Jan 2007 18:11 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 >
|
Next
|
Last
Pages: 1 2 Prev: XML data Error in Excel 2003 Next: The picture is too large and will be truncated |