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

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

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

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

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