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