I have a macro that closes a file while having something copy.

There is a pop up box asking if I want to keep something on the
clipboard.

How do I send a "YES" message through the macro so the user won't be
asked for this prompt?

Before you close that workbook, add a line:

application.cutcopymode = false



Nimish wrote:

I have a macro that closes a file while having something copy.

There is a pop up box asking if I want to keep something on the
clipboard.

How do I send a "YES" message through the macro so the user won't be
asked for this prompt?

--

Dave Peterson

Sub Yes()
Sheets("TempoNonBloquante").Shapes("MyShape").Visi ble = True
TheEnd = Timer + 10
Do While Timer < TheEnd
DoEvents
Loop
Sheets("TempoNonBloquante").Shapes("MyShape").Visi ble = False
End Sub

http://cjoint.com/?lrvoypVOY3

Cordialy JB


Nimish a écrit :

I have a macro that closes a file while having something copy.

There is a pop up box asking if I want to keep something on the
clipboard.

How do I send a "YES" message through the macro so the user won't be
asked for this prompt?