Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

toggle grid

11 views
Skip to first unread message

Todd

unread,
Aug 29, 2003, 9:40:45 PM8/29/03
to
Hi,

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

William

unread,
Aug 29, 2003, 9:48:05 PM8/29/03
to
Todd

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...

Dave Peterson

unread,
Aug 29, 2003, 9:52:41 PM8/29/03
to
Try Tools|customize|commands Tab|Forms category. It's near the bottom (well,
for xl2002 anyway)

(I like this button, too!)

--

Dave Peterson
ec3...@msn.com

Gord Dibben

unread,
Aug 30, 2003, 2:03:01 PM8/30/03
to
Todd

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

Todd Lan

unread,
Aug 31, 2003, 4:23:41 AM8/31/03
to
Thanks very much. I put the button in the workbook and it is wonderful!

Thanks again.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

0 new messages