toggle grid

[Todd]

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]

Todd

Try....

Sub Gridlines()
ActiveWindow.DisplayGridlines = Not ActiveWindow.DisplayGridlines
End Sub
--
XL2002
Regards

William
(e-mail address removed)

| 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

 

[Dave Peterson]

Try Tools|customize|commands Tab|Forms category. It's near the bottom (well,
for xl2002 anyway)

(I like this button, too!)

 

[Gord Dibben]

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]

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!