1. E

    Excel crashed while running macro, now I can't run any macros

    I created a small macro to copy new inputs to the end of a row of cells. The issue that I should've seen coming was that the last row where data was being pasted was in the range being watched, so Excel infinite-loop crashed. When I reopened the workbook the macro didn't respond to changes to...
  2. T

    Displaying Userform Crashes Excel ONLY if it is the First Action After Opening the Workbook

    I have a userform called "ProductDBForm" that uses a multipage to provide detailed data on all products in our range. I use a "Homepage" of sorts with a few images and a transparent box over each with a macro assigned to launch the relevant form or function. One of these is used to launch the...
  3. K

    Excel crashes after execute code

    once in a while when my excel runs this code it crashes and starts in recovery mode, does anyone know what might be happening? Private Sub bt_directorychange_Click() Dim fd As Office.FileDialog 'A variável "fd" irá corresponder á caixa de diálogo Set fd =...
  4. Q

    Closing Userform causes another form to close (crash)

    I have a Userform which, when an item in a ComboBox is selected, brings up another form. This 2nd form is be filled in and closed, returning to the original form. When item A is selected, form A comes up and closes with no problem. When item B is selected, form B comes up and crashes the...
  5. S

    Various Instance of Excel talking to each other crash

    Hello everyone, I am working simultaneously with multiple instances of Excel, as this is a way to utilize more CPU and decrease calculation time per instance. Basically, there is one "Master" instance and several "Slave" instances. When I start the day, I first open the Master Instance, and...
  6. S

    Checkbox crashing/locking up excel resources ONLY when used after another VBA routine

    Hi All! Hoping for some clever people to help out. I'm a VBA novice, but trying my best. Context: I have a large excel tool, with a lot of VBA included. Performance isn't perfect, but it's completely workable. I'm running Office 365 ProPlus 64 bit, other users running 32bit are also having...
  7. M

    My Vba stops working randomly.

    I have a sheet with lot of code. Sometime it just stops working. Sometime it needs a full shut down and sometimes just time !! Anyone else had this issue ?
  8. C

    "SetWindowsHookEx" Crashing Excel x64

    Hello. For a while I've been using the MsgBoxCB sub from Dan Elgaard ( in order to have message boxes with custom button text. Up until now I have been using Excel 2007-2019 x32 and everything has been working perfectly. Recently I started testing my application on Excel 2016...
  9. M

    Excel crashing - multiple interacting macros

    Hi, Please excuse the messy code - I'm entirely self taught and I keep tinkering with the code over time. I have this .xls workbook where I keep separate worksheets for individual share/options trades (file size is 7MB with lots of formulas). I trade overnight, so I have about 4 "sections" of...
  10. L

    VBA crashes randomly in middle of procedure for only one user

    I created a procedure that splits a file into a bunch of smaller workbooks and then emails them using outlook. I rolled this out to approximately 20 users. It works fine on everyone's PC except one person. On her machine the macro seems to run fine and then excel crashes without warning like it...
  11. B

    Unusual VBA Not Responding Issue

    Hi, I have a VBA program that has multiple modules and basically it starts a userform on workbook_open event. Then it goes to a log on screen in the userform. Once a userlogs in the code checks credentials against database to make sure its legit then it goes through a subroutine which basically...
  12. S

    Crashed/Recovered excel ... enable macros greys out everything!

    Desperate: My excel crashed. I rebooted, and downloaded a backup copy of it. Now when i open it, it says: "SECURITY WARNING some active content has been disabled. Click for more details." I instead Enable Content, and when it does so, most features are grayed out, including saving it and even...
  13. G

    Crash When Use SetWindowLongPtrA

    When Hook The Window Class #32770 Through Form , It Does Work Fine But When SubClass This Window Inside CBTProc , System Crash And Hang Up , What s Wrong ? Because Of Not Define Handle Window MayBe Happens Crashing ? In Access Application When Open Form And Hook Window Class #32770 , Again...
  14. D

    Searching in Excel crashing/Flickers

    Hello, this has been an on-going issue but now it's getting out of hand. My excel crashes, I can't close it from the taskbar nor can I CTRL, ALT & DEL, so have to power down. Usually I've got 6-7 spreadsheets open working on a 3 screen setup. Since last night, I tried a few different ways...
  15. D

    VBModeless UserForm Closing/Crashing Excel

    Hi, I have a Userform which opens as "vbModeless," it contains a series of buttons to open more Userforms that all open as "vbModeless." Very simple, but randomly some of the files will immediately close when selecting one of the buttons contained on the first opened form. If I remove the...
  16. S

    Excel 2016 crashes

    I am using Excel 2016 on my work computer and we have a shared file that my boss and I have created. Yesterday, the macro was working fine and you could open it and make changes to it but since then if you try to open the macro it crashes excel. I can open macros and edit them on all other excel...
  17. M

    Excel crashing during VBA procedures

    I have a module called UpdateCheck with procedures which check another document to see if the version number has changed. If it has, it asks the user if they want to update the document to the new version. This is only to update the modules because the formatting of the worksheets is set in...
  18. pleeseemailme

    Excel 2016 Crashes, corrupts file, fixed with office 2013, need help troubleshooting

    Howdy, I have been running a number of processes at my company for years now (many were made possible from contributions from this community - thank you). I now have a new issue with files crashing Excel when loading into memory. The trouble is, it's not every file and its not every time. I...
  19. A

    VBA Excel crashes on ThisWorkbook.Sheets.Copy

    Hi, I've got a macro that basically does the following: Opens data source files, that remain open (aprox. 8 files) Get a key from a list for filtering out data in the source files Copies result for and pastes in corresponding sheet in macro file Refreshes pivot tables and charts to export...
  20. J

    Excel Crashing IF .xlsm file not saved

    Our office is experiencing an issue where Excel will crash if a user does not save a Macro-enabled workbook that they opened. No error message is given. Is anyone else experiencing this issue? Is there anything I can do to troubleshoot what the issue is? Thank you in advance for any help.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back