toggle row/column headings

B

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,
 
B

Bob Phillips

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


--

HTH

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

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)
 
B

Billy

Billy said:
Hi,

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

Thank you very much,
Click to expand...


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
 
Top