Cómo hacer una macro para poner una palomita
Y ahí les va el código, por si lo quieren copiar y pegar.
Sub FlechaVerde() Selection.FormulaR1C1 = "ü" With Selection.Font .Name = "Wingdings" .Size = 12 .Color = -13402799 .TintAndShade = 0 End With With Selection .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter .Interior.Color = 13954269 End With Selection.Borders(xlDiagonalDown).LineStyle = xlNone Selection.Borders(xlDiagonalUp).LineStyle = xlNone With Selection.Borders(xlEdgeLeft) .LineStyle = xlDouble .ThemeColor = 10 .TintAndShade = -0.249946592608417 .Weight = xlThick End With With Selection.Borders(xlEdgeTop) .LineStyle = xlDouble .ThemeColor = 10 .TintAndShade = -0.249946592608417 .Weight = xlThick End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlDouble .ThemeColor = 10 .TintAndShade = -0.249946592608417 .Weight = xlThick End With With Selection.Borders(xlEdgeRight) .LineStyle = xlDouble .ThemeColor = 10 .TintAndShade = -0.249946592608417 .Weight = xlThick End With Selection.Borders(xlInsideVertical).LineStyle = xlNone Selection.Borders(xlInsideHorizontal).LineStyle = xlNone End Sub
Deja una respuesta