Not allowing Multiple Select

[bandit_1981]

Is there a way to not allow them to highlight more then one field and delete them. I have not found a way yet to opnly allow them to select one cell at a time.

Thanks

 

[Von Pookie]

Something like this, maybe?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Application.EnableEvents = False
If Target.Count > 1 Then
    MsgBox "Only one cell may be selected at any time.", vbExclamation
    Target.Cells(1).Select
End If
Application.EnableEvents = True

End Sub

 

[Nimrod]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Count > 1 Then
    MsgBox ("Select only one cell")
    Selection(1, 1).Select
End If
End Sub

TO INSTALL IN SHEET CODE WINDOW:
1. Select the sheet you want code to work in
2. right click the the "Name Tab" of sheet
3. Select "View Code" in drop down menu
4. VBE window will open ... paste code in and exit VBE

 

[bandit_1981]

Cool thanks.