View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
benitAAvi benitAAvi is offline
external usenet poster
 
Posts: 7
Default 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