Disable control down (cntl D) on a worksheet

M

mcpheat

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.
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass value variable to worksheet event 3
VBA code based on column heading 12
Colouring any cell in worksheet with negative value 2
temporarily disabling subroutines 1
Copying Cell Conflict with Worksheet Change to UpperCase 4
Date Stamp 4
Disabling worksheet_change when running a specific macro . . 1
Help with Sub's on a worksheet 4

Top