I am wondering if I can put a button on a worksheet to
utilize the toggle grid function? I am turning off the
grid lines all the time in one worksheet and I move from
one computer to another so adding to the toolbar is a
pain.
TIA
Try....
Sub Gridlines()
ActiveWindow.DisplayGridlines = Not ActiveWindow.DisplayGridlines
End Sub
--
XL2002
Regards
William
willw...@yahoo.com
"Todd" <tun...@hotmail.com> wrote in message
news:06b601c36e97$bb12bbb0$a301...@phx.gbl...
(I like this button, too!)
--
Dave Peterson
ec3...@msn.com
Copy/paste William's macro your workbook then from the Forms Toolbar place a
button on the worksheet and assign the macro to that button.
The macro and the button will travel with the workbook and no need to
customize any Toolbars.
Gord Dibben Excel MVP XL2002
Thanks again.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!