|
No display : keep information in clipboard
Hello,
I open a document and copy the information in the first document. When I close the second document, I have a message which ask me if I want to keep the information in clipboard. Does anyone know how to stop this message ? Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Workbook(€śworkbook2€ť).close (False) -- Alex St-Pierre |
No display : keep information in clipboard
Selection.PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Application.CutCopyMode = False Workbook("workbook2").close (False) -- Regards, Tom Ogilvy "Alex St-Pierre" wrote in message ... Hello, I open a document and copy the information in the first document. When I close the second document, I have a message which ask me if I want to keep the information in clipboard. Does anyone know how to stop this message ? Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Workbook("workbook2").close (False) -- Alex St-Pierre |
| All times are GMT +1. The time now is 10:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com