Hiding ABC and 123

[Chris Meech]

How do I hide the ABC and 123s please?

 

[Max]

Click Tools > Options > View tab
Uncheck "Row & column headers" > OK

 

[AlfD]

Hi!

Tools>Options>then uncheck row and column Headers.

Note: its effect only extends to the sheet which is active when you d
it. AFAIK it can't be made to do the whole workbook. Wish it could
sometimes.

Al

 

[Max]

... AFAIK it can't be made to do the whole workbook.
Wish it could, sometimes ..

Try this sub to do it for the whole workbook:

Sub RemoveRowColHeaders()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Activate
ActiveWindow.DisplayHeadings = False
Next
End Sub

 

[Chris Meech]

Thank you

-----Original Message-----
Click Tools > Options > View tab
Uncheck "Row & column headers" > OK

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----



.

 

[Max]

Chris, you're welcome!
Thanks for feedback.

 

[AlfD]

Hi!

Thanks for that.

Al

 

[Max]

Alf, you're welcome !
Thanks for the feedback.