Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 3rd 21, 12:27 PM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2021
Posts: 1
Default Trapping an Excel crash

Experienced programmers of VBA will know about Excel crashes which is upsetting to our customers. My current crash is when changing a graph axis from decimal to integer, it seems to work on some implementations of Excel but not on others. Does anyone know how to preempt the very specific crash within VBA to take appropriate action? I am aware of 'On Error GoTo ErrorHandler' but am looking for something very local to the offending statement, not something pertinent to the whole procedure.

Last edited by upsidedownhouse : March 3rd 21 at 12:51 PM

  #2   Report Post  
Old March 4th 21, 12:27 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 88
Default Trapping an Excel crash

"upsidedownhouse"

Experienced programmers of VBA will know about Excel crashes which is
upsetting to our customers. My current crash is when changing a graph
axis from decimal to integer, it seems to work on some implementations
of Excel but not on others. Does anyone know how to preempt the crash
within VBA to take appropriate action?


Without more details it's difficult to hazard a guess, we don't even know if
that's changing the chart manually or if code is involved, directly or
indirectly.

Maybe you could upload your file to a file sharing site and explain with
clear steps how to repro' the crash. Also indicate which Excel version(s)
the crash occurs in and if 32 or 64 bit.

Peter T




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 problem trapping Mousup event? Dave Empey Excel Programming 0 September 7th 07 01:02 AM
Trapping Excel events in c# Tim M Excel Programming 0 March 14th 06 06:19 PM
Suppressing or trapping system msgs in excel 2k mike Excel Programming 1 November 17th 04 02:07 AM
Trapping Excel Close Event Bob J.[_2_] Excel Programming 3 December 6th 03 09:57 PM
Trapping Excel Close event Bob J[_2_] Excel Programming 3 December 6th 03 12:56 AM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017