toggle grid
 

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

toggle grid
 

Todd

Try....

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

William


"Todd" wrote in message
...
| 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

toggle grid
 

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

(I like this button, too!)

Todd wrote:

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

toggle grid
 

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

On Sat, 30 Aug 2003 02:48:05 +0100, "William" wrote:

Todd

Try....

Sub Gridlines()
ActiveWindow.DisplayGridlines = Not ActiveWindow.DisplayGridlines
End Sub

toggle grid
 

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!