Thread: Pop Msg Box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Pop Msg Box

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