| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling CTRL R or CTRL D in workbook
I suspect I'd do this in the Workbook_Open event, but am not sure how. Can
someone assist? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling CTRL R or CTRL D in workbook
Use OnKey to assign a 'null' sub to a keystroke to kill it:
Application.OnKey "^d", "" -- Jim "Barb Reinhardt" wrote in message ... |I suspect I'd do this in the Workbook_Open event, but am not sure how. Can | someone assist? | | Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling CTRL R or CTRL D in workbook
Would you do this on Worksheet Open?
"Jim Rech" wrote: Use OnKey to assign a 'null' sub to a keystroke to kill it: Application.OnKey "^d", "" -- Jim "Barb Reinhardt" wrote in message ... |I suspect I'd do this in the Workbook_Open event, but am not sure how. Can | someone assist? | | Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling CTRL R or CTRL D in workbook
Well, I'd do it wherever it made sense depending on when I wanted it to take
effect. The Workbook_Open event would be the place if I wanted it to take place immediately on opening the workbook. The effect of an OnKey is Excel-wide though so if the user switched to another workbook Ctrl-d will be dead there too. That is, unless you use other events like Workbook_Deactivate to turn it off (and Workbook_Activate to set it back on). It can get messy. -- Jim "Barb Reinhardt" wrote in message ... | Would you do this on Worksheet Open? | | "Jim Rech" wrote: | | Use OnKey to assign a 'null' sub to a keystroke to kill it: | | Application.OnKey "^d", "" | | -- | Jim | "Barb Reinhardt" wrote in message | ... | |I suspect I'd do this in the Workbook_Open event, but am not sure how. | Can | | someone assist? | | | | Thanks | | | |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling CTRL R or CTRL D in workbook
How would I turn it back on???
"Jim Rech" wrote: Well, I'd do it wherever it made sense depending on when I wanted it to take effect. The Workbook_Open event would be the place if I wanted it to take place immediately on opening the workbook. The effect of an OnKey is Excel-wide though so if the user switched to another workbook Ctrl-d will be dead there too. That is, unless you use other events like Workbook_Deactivate to turn it off (and Workbook_Activate to set it back on). It can get messy. -- Jim "Barb Reinhardt" wrote in message ... | Would you do this on Worksheet Open? | | "Jim Rech" wrote: | | Use OnKey to assign a 'null' sub to a keystroke to kill it: | | Application.OnKey "^d", "" | | -- | Jim | "Barb Reinhardt" wrote in message | ... | |I suspect I'd do this in the Workbook_Open event, but am not sure how. | Can | | someone assist? | | | | Thanks | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
| Disabling Ctrl-PgUp and Ctrl-PgDn | Excel Programming | |||
| Disabling Ctrl, ALT keys | Excel Programming | |||
Hybrid Mode
