On Row Selection

[JamieArvato]

Is there a event which runs on selection of an entire row?

What I need is that if someone selects a row, ie to delete it it goes to cell - col A and the row they are on and tells them they are unable to select an entire row.

I would use the sheet protect but everytime I do the whole thing locks up?!?!

Thanks

 

[Loomah]

Hi
This is a possible work around. However it also fires if all the columns are manually selected ie range A1:IV9

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Columns.Count = 256 Then
    MsgBox "Can't do that"
    Range("A" & Target.Row).Select
End If
End Sub

Happy Friday

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[Killian01]

well there's the worksheet selection_change event, so you could use this...

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Columns.Count = 256 Then
r = Target.Row
Cells(r, 1).Select
msg = MsgBox("You may not select an entire row.", vbExclamation, "Entire row selected")
End If
End Sub

Enjoy
Killian