Toolbar button for Grid Lines

[dreamplay]

Hi,

I just want to a button on my toolbar for turning grid lines on/off, and can't seem to locate it.
I see a button called "Display Grid" but that's not it.

Can anyone help?
Thanks in advance.

[kingfisher]

I don't have it either. There may be no provision for a shortcut. If that's the case, you will need a simple script to which you can assign a button.

P.S. This script will do what you want. Look for help on installing 'macros'.

Code: Select all

Sub gridlines
' toggles the grid lines between show and hide
If ThisComponent.SupportsService( "com.sun.star.sheet.SpreadsheetDocument" ) Then
ThisComponent.CurrentController.ShowGrid = NOT ThisComponent.CurrentController.ShowGrid
End If
End Sub

[dreamplay]

Thanks, kingfisher
I'll check out the help section on how to install the macro.

[kingfisher]

This thread may help: How to install a macro found here