Pop Msg Box

N

Nimish

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?
 
J

JB

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

http://cjoint.com/?lrvoypVOY3

Cordialy JB


Nimish a écrit :
 
Top