Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable control down (cntl D) on a worksheet
Can you please help me with some code that can be entered into
a worksheet to "disable" a user doing a fill down with "control D". It may be helpful to just disable control "a" to "z" so as to keep control pageup/down still in operation. I suspect it would go into the following private sub Worksheet_Change(ByVal target As Excel.Range) Thanks for your help. Tony. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable control down (cntl D) on a worksheet
Look in Excel VBA help for the onkey command.
Change fires on each edit of a cell - there is probably a better event that will fire less often and still accomplish what you want. -- Regards, Tom Ogilvy "mcpheat" wrote in message ... Can you please help me with some code that can be entered into a worksheet to "disable" a user doing a fill down with "control D". It may be helpful to just disable control "a" to "z" so as to keep control pageup/down still in operation. I suspect it would go into the following private sub Worksheet_Change(ByVal target As Excel.Range) Thanks for your help. Tony. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cntl Key move/select to change in value | Excel Discussion (Misc queries) | |||
Disable and enable dropdown combobox(Form Control) | Excel Discussion (Misc queries) | |||
cntl+f does not find data that I can see in chart | New Users to Excel | |||
How do I disable the ActiveX Control prompt? | Excel Discussion (Misc queries) | |||
Disable Control s | Excel Programming |