events doesnt work
Hi
In excel 2003, i try to use an event located in a worksheet, but it seems that no event works. For exemple, i put this code in sheet1 and i do not get any reaction when selecting a cell.
Private Sub Worksheet_SelectionChange(ByVal Target _
As Excel.Range)
Cells.Interior.ColorIndex = xlNone
With ActiveCell
.EntireRow.Interior.ColorIndex = 1
.EntireColumn.Interior.ColorIndex = 1
End With
End Sub
Only Auto_Open(and Close) events seem to work.
Is there something i did, wrong or do i need to add some reference?
Thanks a lot
Avi
|