Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How can I prevent a user from deleting more than one cell at a time? I have
code that returns the cell's original contents if a user presses delete, but if they highlight several cells and press delete, it doesn't work (the cells' contents are actually deleted). I added a message box to the code as below, but it doesn't actually prevent them from deleting the cells' contents. If Target.Cells.Count 1 Then MsgBox("You can only edit one cell at a time.") Exit Sub End If Thanks, ~ Horatio |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
protect cells in excel to prevent users from deleting formulae | Excel Discussion (Misc queries) | |||
How can I prevent someone from deleting a shared workbook? | Excel Worksheet Functions | |||
How to prevent Excel from deleting leading zeros? | Excel Discussion (Misc queries) | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
How do I prevent someone from deleting a workbook? | Excel Discussion (Misc queries) |