I use the following code to CLEAR gridlines. It resides in personal.xls and
is attached to a custom toolbar button.

Sub ClearGridlines()
ActiveWindow.DisplayGridlines = False
End Sub

If you want a toggle you could use:
Sub ToggleGridlines()
ActiveWindow.DisplayGridlines = not ActiveWindow.DisplayGridlines
End Sub



"Lori" wrote:

Just upgraded to Excel 2003 and can't find the gridline command to drag to my
toolbar - can anyone point me in the right direction. It's buried in the
toolsoptionsview menu. The older version let me put the command on my
toolbar.