Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 295
Default Error Handling function

I've written a generic error handling Public Function which is in
PERSONAL.xls. Is there a way that I can write just a couple of lines of code
in each workbook to call the function on error? I can't see that a
sheetchange event will work becausse the procedure that crashes may not be
updating a sheet at the time.

Maybe there's a way to get Excel to run the function..........? (i.e by just
changing a setting somewhere)

I don't want to go through all the diferent procedures and insert the code
in because there are far too many of them, but there are only about ten
master workbooks that I cycle through. Regards Brett.
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
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Excel Worksheet Functions 13 July 31st 05 03:59 PM
Error handling with a handling routine ben Excel Programming 0 March 15th 05 03:01 PM
Error Handling with a Match Function. Hari Prasadh Excel Programming 5 February 2nd 05 04:11 PM
Error Handling Open Function or query for missing Files BigNate Excel Programming 3 June 11th 04 05:22 PM
Error handling in vba function Jaap Versteegh Excel Programming 4 April 20th 04 02:09 PM


All times are GMT +1. The time now is 11:31 AM.

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

About Us

"It's about Microsoft Excel"