![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Christchurch New Zealand
Posts: 1,030
|
When I use this command when copying a larger amount of data from one workbook to another the macro runs incredibly slow because normally a messagebox will popup asking If you want to save to the data in the clipboard or not
Is there a command to not save the data in the clip board does this make sence or am I not explaining it properly? |
|
|
|
|
|
#2 |
|
Guest
Posts: n/a
|
excel2K
Sub ClearClipboard01() Application.CommandBars("Clipboard").Visible = True Application.CommandBars("Clipboard").FindControl(ID:=3634).Execute Application.CommandBars("Clipboard").Visible = False End Sub Sub ClearClipboard02() Application.CopyObjectsWithCells = False Application.CutCopyMode = False End Sub OR excel97+ Application.cutcopymode=false Ivan |
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|