Turn Gridlines on/off

[JasonP]

Hello

Is there a button in Excel you can press that will turn gridlines on/off rather than going through the tools/options/gridlines route?

Regards

Jason

 

[erik.van.geit]

Hi,

you could write a macro and assign it to a shortcutkey

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

kind regards,
Erik

 

[onlyadrafter]

Hello,

alternatively, use the predefined button (Look in FORMS - TOGGLE GRID) and move this to a toolbar.

 

[JasonP]

Hello

Thanks for that it's great. Is there any way to use that process to add a button to a toolbar so that you can turn the gridlines on/off in any worksheet/workbook?

Regards

Jason

 

[JasonP]

Hello

Ignore my last post, have found the Toggle Grid button as suggested by onlyadrafter

Thanks a lot

Regards

Jason

 

[onlyadrafter]

Hello,

If you're replying to me, you need to select VIEW --> TOOLBARS --> Customize, from the Commands tab, select FORMS, in the window under Commands: scroll down until you see Toggle Grid. Select this with the mouse and drag it into one of the existing toolbars.

When you restart Excel again, it should be there.

 

[Coldwall]

Erik,

The Active Window only works for that sheet. I want to turn the gridlines off in specific tabs. For example I have 14 tabs and I want to write some VBA that when run turns off the gridlines in say 7 of them. Is this possible ?

Thanks
Shane

Hi,

you could write a macro and assign it to a shortcutkey

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

kind regards,
Erik