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!
Bookmarks