+ Reply to Thread
Results 1 to 2 of 2

Change Event slow to Fire

  1. #1
    Registered User
    Join Date
    08-02-2019
    Location
    Boston, MA, USA
    MS-Off Ver
    Excel
    Posts
    2

    Change Event slow to Fire

    I have a Workbook_SheetChange that is slow to fire on a visible sheet under certain circumstances (all other events work normally). When it is slow, it takes a few seconds to fire rather than firing almost instantly.

    The conditions have been isolated to the following:
    1) After I first open a workbook where a) the workbook was saved with hidden/veryhidden sheets b) the OnOpen code applies horizontal borders are applied to cells c) the OnOpen code hides or unhides some rows in code
    Or
    2) Any time I run code that uses NumberFormat (text) in a loop through multiple sheets (whether sheets are hidden or not)

    I always disable/enable events, calculation, screenupdating (etc...) in my code -- that is not the issue. I need to keep some sheets hidden when a workbook is saved or open.

    Does anyone know why the Workbook_SheetChange code would be slow to fire?

  2. #2
    Registered User
    Join Date
    08-02-2019
    Location
    Boston, MA, USA
    MS-Off Ver
    Excel
    Posts
    2

    Re: Change Event slow to Fire

    I think that I found a work around.
    I noticed that when I refreshed a lot of data from a database onto many sheets in an Excel workbook, the Sheet Change delay occurred the first time a cell change was made.

    So part of what I had to do was delete rows from the spreadsheets in order to get the sheet change event to be quick right away.
    I also had to be sure not to change border linestyles on any hidden rows.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting Change event to fire on pasting & autofilling list
    By dluga20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2015, 09:03 PM
  2. ListBox Change Event doesn't fire
    By Michiel93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-03-2015, 10:34 AM
  3. [SOLVED] Fire A Change Event Only When a Cell = 1 in a Range
    By rye123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-04-2013, 07:21 AM
  4. Need help to get code created Userform textboxes to fire a change event
    By brusk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2013, 12:06 AM
  5. [SOLVED] change event delayed fire for data validation list
    By ShoshanaM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2012, 10:32 AM
  6. [SOLVED] Essbase Causing Selection Change Event to Fire
    By Jim Thomlinson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2005, 05:45 PM
  7. Fire Event only when Cell Change?
    By HotRod in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-28-2005, 04:06 PM

Tags for this Thread

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