« PMI CAQ for Information Technology Systems | Main | Fidelity Tips »

October 04, 2002

Light Grid Excel Macro

I like a light hairline grid in my spreadsheets, and there aren't any toolbar buttons that accomplish this. So, I created a macro that does it and then I added a new toolbar button and assigned this macro to it...enjoy.

If you have useful macros to share, drop me a line or use the comments here.

Sub LightGrid()
  If Not Selection Is Nothing Then
    Selection.Borders.LineStyle = xlContinuous
    Selection.Borders.Weight = xlHairline
    Selection.Borders.ColorIndex = xlAutomatic
  End If
End Sub

Posted by Chris at October 4, 2002 08:15 AM

Subscribe to this entry:   Email address:   

Trackback Pings

TrackBack URL for this entry:
http://www.christulino.com/cgi-bin/mt/mt-tb.cgi/33

Comments