Macro_BeforeClose event...Possible??

[Guest]

Hi

Would it be possible to catch when a user prematurely ends a macro by 'Ctrl-Break'? I would like to reset the Statusbar (ie set it to False) before quitting the macro. I guess what I'm looking for is an event similar to the Workbook_BeforeClose..

Many thanks for any suggestions

SuperJas.

 

[Frank Kabel]

Hi
AFAIK there's no such event

 

[Rob van Gelder]

Take a look at Application.EnableCancelKey


--
Rob van Gelder - http://www.vangelder.co.nz/excel

Hi,

Would it be possible to catch when a user prematurely ends a macro by

'Ctrl-Break'? I would like to reset the Statusbar (ie set it to False)
before quitting the macro. I guess what I'm looking for is an event similar
to the Workbook_BeforeClose...

 

[Chip Pearson]

You can use the Application.EnableCancelKey property to control
how VBA responds to Ctrl+Break. For example

Application.EnableCancelKey = xlErrorHandler
On Error GoTo ErrHandler:
'
' your code here
'
Exit Sub
ErrHandler:
If Err.Number = 18 Then
MsgBox "You pressed break"
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Hi,

Would it be possible to catch when a user prematurely ends a

macro by 'Ctrl-Break'? I would like to reset the Statusbar (ie
set it to False) before quitting the macro. I guess what I'm
looking for is an event similar to the Workbook_BeforeClose...