PDA

View Full Version : Excel vba crashes?



GhostofDoom
01-08-2020, 10:28 AM
Hello,

how can i terminate the entire excel program when it crashes? like when there is an error in the vba code
the dialog comes and we close it and that's it
and when you start excel again or the file it will say that the file already has been opened

but we like to ignore that so when the error message popup i like to terminate the whole program

any idea's please?

Thanks

Leith Ross
01-08-2020, 10:50 AM
Hello GhostofDoom,

I use the keys Ctrl+Alt+Del and select "Start the Task manager". Click the "Processes" tab and select EXCEL.EXE then click the "End Process" button in the lower right corner.

Dave
01-08-2020, 11:33 AM
Take a look at my post here... https://www.mrexcel.com/board/threads/how-to-detect-bypass-the-workbook-recovery-window-and-process.1114537/page-2
It works for Windows 10 and office 2016. HTH. Dave

GhostofDoom
01-08-2020, 11:41 AM
Hello Leith Ross (http://www.vbaexpress.com/forum/member.php?47139-Leith-Ross) ,
thanks for the help
but we like to terminate at once when the dialog error has been closed ;)

thanks anyway, but good for next time when we just use excel without vba :thumb

GhostofDoom
01-08-2020, 11:44 AM
Hello Dave,

okay i see you are using the register... but we can't use that because
the computers we use at work are protected with lots of passwords so it's not allowed to access anything without the correct login :(
any other solutions please :)

Thanks

snb
01-08-2020, 02:40 PM
any other solutions please :)

You sound like an auctioneer