+ Reply to Thread
Results 1 to 4 of 4

Excel freezes when I use the mouse wheel on an xlsm file...

  1. 05-22-2020, 10:57 PM #1
    Ulnarian
    Ulnarian is offline
    Registered User
    Join Date
    11-03-2006
    MS-Off Ver
    365
    Posts
    63

    Excel freezes when I use the mouse wheel on an xlsm file...

    I have a macro-enabled Excel file, and, after I launch the macro, as soon as I try to use the mouse wheel to scroll through the workbook, everything freezes on me. The macro appears to run correctly, and, if I scroll through the workbook with the arrow keys or with page-up and page-down, I don't run into any issues. But, as soon as I use the mousewheel, I can no longer do anything with workbook other than close it out.

    Has anyone run into this before or know of a solution (other than just not using the mouse wheel ).

    Thanks!
    Last edited by Ulnarian; 05-23-2020 at 01:02 AM.
    Reply With QuoteRegister To Reply
  2. 05-22-2020, 11:22 PM #2
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Excel freezes when I use the mouse wheel on an xlsm file...

    .
    If it started with the creation of the macro ... what does the macro do ?

    Post your code.
    Reply With QuoteRegister To Reply
  3. 05-23-2020, 12:51 AM #3
    Ulnarian
    Ulnarian is offline
    Registered User
    Join Date
    11-03-2006
    MS-Off Ver
    365
    Posts
    63

    Re: Excel freezes when I use the mouse wheel on an xlsm file...

    Hi Logit,

    I was actually going to send you a copy of the code, but, I decided to do some optimization on it first. And..this seems to have resolved the issue!

    In case anyone is still wondering, the macro uses MSXML2 to parse XML data and updates cell values based on selected nodes. I didn't really know of a way to loop through the exact number of node occurrences until 10 minutes ago, so I was using an arbitrary "For i = 0 to 100" loop. I've just discovered the .length property which lets me determine the exact # of nodes to loop through. Implementing this seems to have resolved the issue.

    Thanks!
    Reply With QuoteRegister To Reply
  4. 05-23-2020, 10:44 AM #4
    Logit
    Logit is offline
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Excel freezes when I use the mouse wheel on an xlsm file...

    .
    So glad you found an answer.

    Cheers !
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Why does mouse scroll wheel change directions in Excel?
    By Perplexed in forum Excel General
    Replies: 0
    Last Post: 07-19-2006, 02:05 PM
  2. Fix for mouse wheel in VBE
    By XP in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-18-2006, 02:10 PM
  3. Navigate Excel with mouse wheel.
    By Gene in forum Excel General
    Replies: 4
    Last Post: 03-16-2006, 08:45 PM
  4. Why does my mouse wheel scroll from left to right in Excel 2003?
    By Mike in forum Excel General
    Replies: 3
    Last Post: 01-27-2006, 01:20 PM
  5. [SOLVED] Opening files in Excel with mouse wheel set for doubleclick
    By walshie in forum Excel General
    Replies: 0
    Last Post: 10-03-2005, 06:05 AM
  6. [SOLVED] STOP the zooming! Mouse scroll wheel in Excel 2004... on a Mac
    By [email protected] in forum Excel General
    Replies: 12
    Last Post: 09-09-2005, 02:05 AM
  7. [SOLVED] How do I use the mouse wheel to scroll horizontally in excel?
    By Alison in forum Excel General
    Replies: 4
    Last Post: 08-17-2005, 06:05 AM
  8. Mouse Wheel & Mouse Drivers
    By Otto Moehrbach in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-07-2005, 05:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1