turning off pop up message
 

Hello all,

The app I'm writing for my wife's office copies a worksheet of 'master
data' into the local workbook that's running the code. Once copied, I
close the 'master data' workbook. The code works as desired, except
that I get a message telling me there's "a large amount of info on the
clipboard. Do you want to be able to paste it..."

I've turned off what I can (application.displayalerts = false), but
that's obviously not eliminating this message.

It doesn't affect the functionality or execution of the app, but it
would certainly be less intrusive on the user if I could get this to
go away.

Suggestions?

Art

turning off pop up message
 

Application.CutCopyMode = False

Place in your code after the copy operation.


Gord Dibben MS Excel MVP

On Thu, 20 Aug 2009 18:32:44 -0700 (PDT), c1802362 wrote:

Hello all,

The app I'm writing for my wife's office copies a worksheet of 'master
data' into the local workbook that's running the code. Once copied, I
close the 'master data' workbook. The code works as desired, except
that I get a message telling me there's "a large amount of info on the
clipboard. Do you want to be able to paste it..."

I've turned off what I can (application.displayalerts = false), but
that's obviously not eliminating this message.

It doesn't affect the functionality or execution of the app, but it
would certainly be less intrusive on the user if I could get this to
go away.

Suggestions?

Art

turning off pop up message
 

Gord,

with the line of code you suggested, the sheet is created, but no data
is copied to the sheet. I tried it a bunch of ways and its always the
same.

any other suggestions?

Art


On Aug 20, 10:03*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Application.CutCopyMode = False

Place in your code after the copy operation.

Gord Dibben *MS Excel MVP

turning off pop up message
 

I should have said after the "paste" operation.

My apologies.


Gord

On Thu, 20 Aug 2009 19:43:12 -0700 (PDT), c1802362 wrote:

Gord,

with the line of code you suggested, the sheet is created, but no data
is copied to the sheet. I tried it a bunch of ways and its always the
same.

any other suggestions?

Art


On Aug 20, 10:03*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Application.CutCopyMode = False

Place in your code after the copy operation.

Gord Dibben *MS Excel MVP

turning off pop up message
 

On Aug 21, 3:59*pm, Gord Dibben <gorddibbATshawDOTca wrote:
I should have said after the "paste" operation.

My apologies.

Gord

Gord,

No problem. Everything works fine after the right line goes in the
right place. After I had unsuccessfully tried to put the cutcopymode
line after the copy operation, I decided to be a bit crude and added
Range("A1").Copy right after the paste, which had the effect of
reducing the large clipboard to one cell - which would eliminate the
pop up

Thanks!

Art