Boa noite
Preciso alterar esse código para o change da planilha, mas nun deu.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim wks As Worksheet
Dim rngX As Range
Dim rngNumber As Range
Dim lngNumbersCol As Long
If Not TypeName(Sh) = "Worksheet" Then Exit Sub
If Intersect(Range(gcstrX), Target) Is Nothing Then Exit Sub
If LCase(Target.Value) <> "x" Then Exit Sub
lngNumbersCol = Sh.Range(gcstrNumbers).Column
Application.EnableEvents = False
For Each wks In ThisWorkbook.Worksheets
For Each rngX In wks.Range(gcstrX)
If wks.Cells(rngX.Row, lngNumbersCol) = Cells(Target.Row, lngNumbersCol) Then
wks.Cells(rngX.Row, lngNumbersCol).Interior.color = vbYellow
If wks.Cells(rngX.Row, lngNumbersCol) = Cells(Target.Row, lngNumbersCol) Then
wks.Cells(rngX.Row, lngNumbersCol).Font.color = vbYellow
End If
End If
Next rngX
Next wks
Application.EnableEvents = True
End Sub
Postado : 30/07/2014 4:03 pm