I am familiar working with application events such as before workbook close etc...however my current issue is this - I have a script that spell checks a specific range of cells, skipping cells with a specific criteria. As a result of this approach, the check spelling application is opened within a loop - I would like to trap/capture when the user hits Cancel or the red X to close the app so I can then exit the loop before re-launching the app in the next loop. This is not a custom form, so is there a reference to all application events for all apps (such as spell check) within Excel? Example that is not accurate but will give you an idea of what I am looking for - this is adapted from a Form control example:
Private Sub application_Spelling(Cancel As Integer, CloseMode As Integer)
If cancelled or closed Then exit the calling sub
Bookmarks