1. 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...
  2. 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...
  3. 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...
  4. 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 ?
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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.
  18. M

    Information: Calculation crash with VBA, reason found

    Hi All, After some hours of investigation, I found a Excel crash issue under this conditions: 1. on VBA you use a calculation only on some rows or columns 2. you have pivot table in same sheet => this makes Excel crash when you save or change sheet. Hope this information will be usefull for you all.
  19. A

    Excel 2016 - Pivot Charts customization causes Excel to crash...

    Every time I need to create a pivot chart and I start customizing the colors on the filters, excel will inevitably crash and restart itself - sometimes offering a repaired version of my excel file. Most times it just reopens wherever i last saved any updates. Why is the chart customization...
  20. N

    PowerQuery / Get & Transform not working

    Hi, have anybody experienced where their Excel version's Get & Transform is unresponsive? I have created a file and done some queries etc just to have it crash and now it does not even recognise that I had a query. Thank you.

Watch MrExcel Video

This Week's Hot Topics

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