turning off pop up message

  • Thread starter Thread starter c1802362
  • Start date Start date
C

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
 
Application.CutCopyMode = False

Place in your code after the copy operation.


Gord Dibben MS Excel MVP
 
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
 
I should have said after the "paste" operation.

My apologies.

Gord
Click to expand...
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
 
Back
Top