Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Vba application.displayalerts=false very Slow

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    Guest

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •