Share via

why do not responding Visual Basic Application in desktop computer how to solve it

Anonymous
2017-10-21T13:35:17+00:00

why do not responding Visual Basic Application in desktop computer how to solve it

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. OssieMac 48,001 Reputation points Volunteer Moderator
    2017-10-21T23:59:04+00:00

    Difficult, if not impossible, to assist without a copy of the VBA code.

    However, check the following

    If there are any loops in the code then ensure that the code is not is not going into an endless loop.

    Ensure not trying to process all cells on the worksheet. While technically this should work, I have seen the "Not Responding" when a user has referenced cells (which is all cells on the worksheet) instead of referencing  a much smaller range.

    Was this answer helpful?

    0 comments