View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Esssa Esssa is offline
external usenet poster
 
Posts: 4
Default Script Not working

hi

Private Sub Worksheet_SelectionChange(ByVal Target _
As Excel.Range)
Cells.Interior.ColorIndex = xlNone
With ActiveCell
.EntireRow.Interior.ColorIndex = 40
.EntireColumn.Interior.ColorIndex = 36
End With
End Sub

the above script works only single worksheet not all workbooks despite
i made adds-in. Please advise that how can i able the above script to
all excel sheets

thanks in advacne

AE