Disabling clipboard prompt
 

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

Disabling clipboard prompt
 

Application.CutCopyMode = False

Entered above "End Sub"


Gord Dibben MS Excel MVP

On Fri, 15 Aug 2008 08:25:54 -0700 (PDT), wrote:

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

Disabling clipboard prompt
 

You can clear the clipboard before closing:

application.cutcopymode = false
'code to close

wrote:

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

--

Dave Peterson

Disabling clipboard prompt
 

Gord/Dave:

Thank you, saves me a whole lot of frustration.


S

On Aug 15, 12:19*pm, Dave Peterson wrote:
You can clear the clipboard before closing:

application.cutcopymode = false
'code to close

wrote:

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

--

Dave Peterson