Microsoft Office Tutorials and References
In Depth Information
USE A MACRO TO HIGHLIGHT THE ACTIVE CELL
USE A MACRO TO HIGHLIGHT
THE ACTIVE CELL
Challenge: Microsoft changed the selection highlighting in Excel 2007. If you
select 20 cells, Excel highlights those cells in super-ultra-light blue. Imagine if
you had 5 gallons of white paint and dropped in one drop of blue paint. That
paint would have more color than the new selection color in Excel 2007. You
want to highlight the active cell so it’s easier to spot.
Solution: There is a cool event macro that can add a splash of color to the
selection and draw crosshairs to help you locate the row and column where the
active cell is located. In Figure 141, bright yellow highlight indicates the active
cell in D16. Lighter yellow is used to mark column D and Row 16. As you move
the cell pointer, the highlights change. Figure 142 shows the crosshairs pattern
Figure 141. h e macro draws yellow highlights to help you
locate the active cell.
Figure 142. As you move to a dif erent cell, the
yellow highlights move to track the active cell.