Gµstavo
19-04-2011 19:13:51
Pessoal,
Eu encontrei o codigo abaixo que destaca a celula ativa, funciona perfeitamente, o que estou precisando e transformar esse codigo num suplemento par que qualquer planilha aberta ele destaque a celula ativa.
Grato,
==================================================================
Option Explicit
Public celAnt As String
Public corAnt As Integer
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
On Error Resume Next
If celAnt = "" Then
celAnt = Range("A2").Value
corAnt = Range("A1").Value
Range(celAnt).Interior.ColorIndex = corAnt
corAnt = Target.Interior.ColorIndex
Range("A1").Value = corAnt
Target.Interior.Color = vbYellow
celAnt = Target.Address
Range("A2").Value = celAnt
Else
Range(celAnt).Interior.ColorIndex = corAnt
corAnt = Target.Interior.ColorIndex
Range("A1").Value = corAnt
Target.Interior.Color = vbYellow
celAnt = Target.Address
Range("A2").Value = celAnt
End If
End Sub
==================================================================
Eu encontrei o codigo abaixo que destaca a celula ativa, funciona perfeitamente, o que estou precisando e transformar esse codigo num suplemento par que qualquer planilha aberta ele destaque a celula ativa.
Grato,
==================================================================
Option Explicit
Public celAnt As String
Public corAnt As Integer
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
On Error Resume Next
If celAnt = "" Then
celAnt = Range("A2").Value
corAnt = Range("A1").Value
Range(celAnt).Interior.ColorIndex = corAnt
corAnt = Target.Interior.ColorIndex
Range("A1").Value = corAnt
Target.Interior.Color = vbYellow
celAnt = Target.Address
Range("A2").Value = celAnt
Else
Range(celAnt).Interior.ColorIndex = corAnt
corAnt = Target.Interior.ColorIndex
Range("A1").Value = corAnt
Target.Interior.Color = vbYellow
celAnt = Target.Address
Range("A2").Value = celAnt
End If
End Sub
==================================================================