como puedo cambiarle la linea a este codigo que en vez de colorear me bordee la celda
Sub Macro1()
'
' Macro1 Macro
'
'
Sheets("hoja1").Select
With ActiveWorkbook.Sheets("programa4cifras").Tab
.color = 255
.TintAndShade = 0
End With
Sheets("hoja2").Select
With ActiveWorkbook.Sheets("hoja2").Tab
.ThemeColor = xlThemeColorAccent6
.TintAndShade = -0.249977111117893
End With
Sheets("hoja3").Select
With ActiveWorkbook.Sheets("hoja3").Tab
.ThemeColor = xlThemeColorAccent1
.TintAndShade = -0.249977435298762
End With
Sheets("hoja4").Select
With ActiveWorkbook.Sheets("hoja4").Tab
.ThemeColor = xlThemeColorAccent4
.TintAndShade = 0.399975585192419
End With
Sheets("hoja6").Select
With ActiveWorkbook.Sheets("hoja5").Tab
.ThemeColor = xlThemeColorAccent4
.TintAndShade = 0.399975554321
End Sub
Featured Replies
Archivado
Este tema está ahora archivado y está cerrado a más respuestas.
como puedo cambiarle la linea a este codigo que en vez de colorear me bordee la celda
Sub Macro1() ' ' Macro1 Macro ' ' Sheets("hoja1").Select With ActiveWorkbook.Sheets("programa4cifras").Tab .color = 255 .TintAndShade = 0 End With Sheets("hoja2").Select With ActiveWorkbook.Sheets("hoja2").Tab .ThemeColor = xlThemeColorAccent6 .TintAndShade = -0.249977111117893 End With Sheets("hoja3").Select With ActiveWorkbook.Sheets("hoja3").Tab .ThemeColor = xlThemeColorAccent1 .TintAndShade = -0.249977435298762 End With Sheets("hoja4").Select With ActiveWorkbook.Sheets("hoja4").Tab .ThemeColor = xlThemeColorAccent4 .TintAndShade = 0.399975585192419 End With Sheets("hoja6").Select With ActiveWorkbook.Sheets("hoja5").Tab .ThemeColor = xlThemeColorAccent4 .TintAndShade = 0.399975554321 End Sub