Change F1 functionkey and disable CTRL-Break

G

Guy Van der Sande

I've got two questions :
1. I would like excel to call my own helpfile when I press
F1.
2. I would like to disable the CTRL-Break functionallity
while a macro is running.

Does anyone know how I can achieve those things ?

Thanks
Guy Van der Sande
[email protected]
 
C

Chip Pearson

Guy,

You can use Application.OnKey to assign a macro to the F1 key. See help for
OnKey for more details. You can use Application.EnableCancelKey =
xlDisabled to disable Ctrl+Break. Be careful with this setting -- if you
get in an infinite loop, you won't be able to break out of it without using
Ctrl+Alt+Delete.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]
 
Top