Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Have tried various methods and can't seem to get this Macro to apply to all
the worksheets (January, Feb, March, etc.) in the workbook. Can only get it to apply to the first one, so you'll see that the January one is the only one listed below.... Sub StartBlink() With ThisWorkbook.Worksheets("January").Range("d2:d4"). Font If .ColorIndex = 3 Then ' Red Text .ColorIndex = 2 ' Yellow Text Else .ColorIndex = 3 ' Red Text End If End With RunWhen = Now + TimeSerial(0, 0, 1) Application.OnTime RunWhen, "'" & ThisWorkbook.Name & "'!StartBlink", , True End Sub -- News Gal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Apply Conditional Format to all sheets in same workbook | Excel Discussion (Misc queries) | |||
Apply Macro to all worksheets in a workbook except one | Excel Discussion (Misc queries) | |||
apply Macro to all sheets in workbook - loop | Excel Programming | |||
how to apply the same header or footer to all sheets in workbook | Excel Worksheet Functions | |||
apply a macro to all sheets except for a certain sheet | Excel Discussion (Misc queries) |