turning off pop up message

[c1802362]

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 Dibben]

Application.CutCopyMode = False

Place in your code after the copy operation.


Gord Dibben MS Excel MVP

 

[c1802362]

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

 

[Gord Dibben]

I should have said after the "paste" operation.

My apologies.


Gord

 

[c1802362]

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