Change F1 functionkey and disable CTRL-Break

[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
(e-mail address removed)

 

[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 (e-mail address removed)

 

[Guy Van der Sand]

Thanks Chip, you helped me a lot.

G's,
Guy Van der Sande
(e-mail address removed)