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

Application.CutCopyMode = False

Entered above "End Sub"


Gord Dibben MS Excel MVP

On Fri, 15 Aug 2008 08:25:54 -0700 (PDT), (E-Mail Removed) 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

You can clear the clipboard before closing:

application.cutcopymode = false
'code to close

(E-Mail Removed) 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

Gord/Dave:

Thank you, saves me a whole lot of frustration.


S

On Aug 15, 12:19*pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> You can clear the clipboard before closing:
>
> application.cutcopymode = false
> 'code to close
>
> sbit...@gmail.com 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