Stop user from pressing the "Delete" key in speci

[MattOCUSA]

I have 3 cells on 1 worksheet which I cant have the user delete by pressing the "Delete" key on the keyboard.

I need to allow the user to select the 3 cells for other reasons, so protecting the cells wont work in this case. I'm wondering how to do it via worksheet event code? I'd need something that would replace the value in the cell if they deleted the contents of the cell by pressing the delete key in those cells?

Thank You!
Matt

 

[Lewiy]

If the values in these particular cells are always going to be the same, then you could use something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" And Target.Value <> 2 Then Target.Value = 2
End Sub

Repeat the “If” line for each cell address as required.

This particular example will return cell A1 to the value “2” if it is changed/deleted.

 

[MattOCUSA]

Hi thanks. The user enters a value into these cells via an Input Box. The values change though or else that would work.

 

[Lewiy]

The only other way I can think of doing this then, is to use the input box to enter the value into both the cell that it currently is doing and also another (possibly hidden) cell on the worksheet. Then refer to the hidden cell in the code rather than the constant value “2”.

Incidentally, what other reasons do you need the users to select the cells for? Is it not something you can customise in the protect worksheet dialog box? (assuming you are using later than xl2000 version).

 

[MattOCUSA]

Hi, thanks for the ideas. I ended up solving it.

THANK YOU for taking time to help out.

Matt