1. B

    Macro crashing and closing excel

    Hi guys, I need some help. I have a file with a few macros, and it was everything working as expected, but today my excel started crashing and closing when I run one of the macros. I was making changes to the file, and the macro was working, but sudently, It started closing excel. The code is...
  2. SkywardPalm

    Excel file crashes when setting variable to Sheet1

    Sub Sheet_Select() Dim sht As Worksheet 'select Macro Controls Sheet Set sht = Sheet1 sht.Select My excel file crashes when the macro runs (on Set sht), but only on certain devices. It doesn't throw any errors and tries to re-open in safe mode. Any advice would...
  3. V

    VBA Code Works Until I Reopen PPT File

    Anyone know why a VBA code might work, and then I save and close the file, and when I reopen it, the code doesn't work anymore? Previously the file was crashing whenever I tried to copy & paste code within the VBA module, and again when I would reopen the code would no longer work...
  4. L

    Excel crashing launching macro after closing userform

    Good Morning, After closing a userform excel crash when I start a macro. Macros, before open userform, works very well. I try to set focus back to excel with ThisWorkbook.Application.Caption and also Private Sub UserForm_Terminate() Unload Me Sheets(“MySheet”).Activate End Sub Thanks
  5. B

    Excel stops working after VBA runs workbook.close on a big file (1.7GB)

    Hi, Is this a known problem that VBA stops working on workbook.close if it is trying to close a big file (1.7GB). My code basically only needs to open the file, copy all the information into a sheet on the workbook with the macro and then close the file. It does everything perfectly but on the...
  6. B

    VBA Loop Crashing Excel

    Hello - I have a need to consolidate data from two worksheets in 2,700 workbooks into two worksheets in 1 big workbook. I have a piece of code that works well enough, but after a varying number of loops it crashes excel altogether. Sometimes it may make it through 10 files, others it may get...
  7. P

    Excel for Mac - VBA to Create PowerPoint Presentation

    Hi all, I'm a Mac user. I'm trying to create a PPT using VBA in Excel to copy a few tables and charts to different slides. However, whenever my script reaches PowerPoint commands, such as the one below, PowerPoint or Excel crash completely and close Set pptPres =...
  8. M

    VBA: Excel crashes opening file with comments.

    I have an Excel file with a VBA project that had been working just fine until recently. I have finally tracked the problem but it does not make much sense: At one point, the code within the Excel file opens another file to get a value—this second file is provided by an outside third-party. When...
  9. E

    Script Crashes when run with anything but MsgBox test text.

    I'm new to excel VBA but I have now tested each part and they work correctly. What I'm trying to do is to simply delete the contents of a cell when the cells formula value is changed(no selection on entering key needed). The code is located under the sheet it runs in . Private Sub...
  10. 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...
  11. 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...
  12. 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 =...
  13. 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...
  14. 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...
  15. 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...
  16. 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 ?
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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