Disabling clipboard prompt

[sbitaxi]

Hello:

When I close a workbook in a macro, I get a prompt asking "Are you
sure? There is a lot of data in the clipboard." How do I disable this
prompt?


Steven

 

[Gord Dibben]

Application.CutCopyMode = False

Entered above "End Sub"


Gord Dibben MS Excel MVP

 

[Dave Peterson]

You can clear the clipboard before closing:

application.cutcopymode = false
'code to close

 

[sbitaxi]

Gord/Dave:

Thank you, saves me a whole lot of frustration.


S