Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would STRONGLY recommend that you NOT disable CTRL+ALT+DELETE. That is a
system wide function that users may need for applications other than yours. There are certain things that an application shouldn't do, even if it is possible to do so. This, and changing display resolution, are at the top of that list. I would not use an app that did either of these things. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "jutlaux" wrote in message ... I have a excel workbook that is via VBA goes out to various 3rd party applications and gets data from them. The problem I have is that this is not instantaneous and even tough I have a progress bar showing things moving along the user will hit CTRL+ALT+DEL and end the task. This is not a problem for excel, but the other software applications seem to be getting "hung up" b/c the data transfer is not complete. Is there a way when this workbook is opened to disable the CTRL+ALT+DEL function? I have tried using: Application.OnKey "^%{DEL}", "NotAllowed" but nothing happens. I have even tried just looking for the CTRL + ALT Application.OnKey "^%", "NotAllowed" but with this I get run-time error 1004 and if I change it to Application.OnKey "^{%}", "NotAllowed" or Application.OnKey "%{^}", "NotAllowed" nothing happens |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a difference between CTRL+D and CTRL+" (quotation marks) | Excel Discussion (Misc queries) | |||
How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
Redefining the Ctrl [ and Ctrl ]s short cut with OnKey? | Excel Programming | |||
Disabling Ctrl-PgUp and Ctrl-PgDn | Excel Programming |