Results 1 to 12 of 12

Simple VBA Macro freezing computer

Threaded View

lespaul00 Simple VBA Macro freezing... 12-15-2016, 12:37 AM
bakerman2 Re: Simple VBA Macro freezing... 12-15-2016, 02:19 AM
lespaul00 Re: Simple VBA Macro freezing... 04-20-2017, 09:38 PM
humdingaling Re: Simple VBA Macro freezing... 04-20-2017, 09:41 PM
Norie Re: Simple VBA Macro freezing... 04-20-2017, 09:42 PM
lespaul00 Re: Simple VBA Macro freezing... 04-20-2017, 10:25 PM
humdingaling Re: Simple VBA Macro freezing... 04-20-2017, 11:06 PM
lespaul00 Re: Simple VBA Macro freezing... 04-20-2017, 11:25 PM
humdingaling Re: Simple VBA Macro freezing... 04-20-2017, 11:34 PM
JieJenn Re: Simple VBA Macro freezing... 04-21-2017, 12:34 AM
jolivanes Re: Simple VBA Macro freezing... 04-21-2017, 02:31 AM
lespaul00 Re: Simple VBA Macro freezing... 04-21-2017, 09:25 AM
  1. #1
    Registered User
    Join Date
    06-09-2008
    Posts
    24

    Simple VBA Macro freezing computer

    Hello. I created some simple VBA macro buttons to help navigate around a sheet within a .xlsm file I have. I have about 10 different macro buttons that do this, and simply jump to a different cell in the sheet. Here's an example:

    Sub goto_section1()
    'Select the section to jump to
    Range("A141").Select
    'Make the selected cell the first row
    ActiveWindow.ScrollRow = ActiveCell.Row
    End Sub

    These have worked flawlessly, but recently, every once in awhile a click of one of these buttons will freeze my computer. Basically, the "processing circle" appears as my cursor, it says "Excel is not responding" and I can't even click anything on my computer desktop, taskbar, etc. I can't even pull up the Task Manager to terminate Excel. Nothing works, and I must hard reboot my computer.

    Sometimes this happens and sometimes it does not. I'd say it's become about 25% chance of happening now. Here is some more information:
    - The file size is less than 1MB
    - All VBA code is under Module1 in VBA
    - The file is located on a shared drive in our office
    - I included an image I took a picture of (since I couldn't screenshot when it froze!)

    Any help/feedback is appreciated!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to design a simple guessing game, played by one player against the computer.
    By Papsco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2015, 10:40 PM
  2. macro freezing - too many words?
    By labmanager in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-27-2013, 03:01 PM
  3. coin toss programme for MS Excel
    By mayf92 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2013, 09:27 AM
  4. macro keeps freezing
    By theinexplicablefuzz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-18-2011, 03:15 PM
  5. Macro freezing sheet on one pc
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2009, 08:21 AM
  6. Auto Filter on my home computer differs from my work computer.
    By Sbova0226 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-08-2009, 03:04 PM
  7. Why is Computer Freezing With Excel?
    By heitorfjr in forum Excel General
    Replies: 1
    Last Post: 01-15-2006, 01:16 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1