View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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