Change F1 functionkey and disable CTRL-Break

  • Thread starter Thread starter Guy Van der Sande
  • Start date Start date
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
(e-mail address removed)
 
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)
 
Thanks Chip, you helped me a lot.

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