Results 1 to 9 of 9

Screen Updating Not Completely Disabled in Excel Macro

Threaded View

  1. #1
    Registered User
    Join Date
    01-07-2012
    Location
    Pleasanton, CA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Screen Updating Not Completely Disabled in Excel Macro

    Hi - I have an Excel macro that pulls data from Access queries, populating several different worksheets in the Excel file. I've disabled screen updating in the VBA code and that works fine...none of the operations performed in the worksheets are shown on screen. However, when I activate different worksheets in the code, the screen does show all the switching between worksheets, which is annoying and I don't want the users to see it. I thought turning off screen updating would take care of that, but I guess not. Does anyone know how to just stay on the worksheet where the user clicks the button to start the macro?

    Thanks,

    Jeff
    Last edited by jstroope; 01-10-2012 at 11:03 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