+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    11-03-2006
    MS-Off Ver
    365
    Posts
    57

    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.

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,291

    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.

  3. #3
    Registered User
    Join Date
    11-03-2006
    MS-Off Ver
    365
    Posts
    57

    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!

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    5,291

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

    .
    So glad you found an answer.

    Cheers !

+ Reply to Thread

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