toggle row/column headings

[Billy]

Hi,

I need a procedure to toggle on/off row and column headings. Can this
be done? I use XL97.

Thank you very much,

 

[Bob Phillips]

Sub RowColumn()
With ActiveWindow
.DisplayHeadings = Not .DisplayHeadings
End With
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

You could use a toggle button from the control toolbox toolbar and use
something like this

Private Sub ToggleButton1_Change()
If ToggleButton1.Value Then
ActiveWindow.DisplayHeadings = False
Else
ActiveWindow.DisplayHeadings = True
End If
End Sub

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Billy]

Hi,

I need a procedure to toggle on/off row and column headings. Can this
be done? I use XL97.

Thank you very much,

Bob & Peo,

Thanks very much! I used Bob's procedure and created an icon and now
have it in my Personal macro workbook and can use it on all my Excel
applications. Thank you both again for your timely and expert advise!
Billy