Results 1 to 15 of 15

Turning off visuals when I use a macro button.

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2011
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 2007
    Posts
    31

    Turning off visuals when I use a macro button.

    I am new to VBA so on my last project I used a macro to get parts of the code I am using. However, the code causes the screen to flicker back and forth between worksheets as some copying and pasting takes place. Is it possible to turn this flickering off and just have the code "do its thing?"

    Below is some of the code I used.
        Selection.Copy
        Sheets("Template").Select
        Range("G2").Select
        ActiveSheet.Paste
        
        Sheets("Load").Select
        ActiveCell.Offset(0, 2).Range("A1").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Template").Select
        ActiveCell.Offset(0, 2).Range("A1").Select
        ActiveSheet.Paste
        
        'Copy node and paste.
        Sheets("Load").Select
        ActiveCell.Offset(0, 1).Range("A1").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Template").Select
        ActiveCell.Offset(0, 1).Range("A1").Select
        ActiveSheet.Paste
    EDIT: I should mention I am using a button to initiate my code.
    Last edited by Brad4444; 04-05-2011 at 11:47 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1