daveyboyh
11-30-2005, 08:36 AM
I am running a macro in Excel that will systematically open up a worksheet, copy their contents to a "master" sheet and then close, before moving on to the next worksheet.
The problem occurs when the work sheet from which the data has been copied to the master sheet closes. I can ensure that the message box asking if I want to save changes doesn't appear (ActiveWindow.Close (False)), but cannot automatically say "No" to the message box asking if I want to save the information in the clipboard.
Hopefully someone can understand the above (!!!) and help me!
Cheers:banghead:
The problem occurs when the work sheet from which the data has been copied to the master sheet closes. I can ensure that the message box asking if I want to save changes doesn't appear (ActiveWindow.Close (False)), but cannot automatically say "No" to the message box asking if I want to save the information in the clipboard.
Hopefully someone can understand the above (!!!) and help me!
Cheers:banghead: