Hiding ABC and 123

A

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
 
M

Max

AlfD > said:
... 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
 
C

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



.
 
Top