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. |
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. |
All times are GMT +1. The time now is 12:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com