Column, Row and Sheet tab are gone

[Elton Law]

Hi expert,
Someone send me a file which made the column header (A, B, c ...) and the
row number (1,2,3,4 ...) are gone.
How can I put them back please?
Also, the sheet tab are gone too. (Sheet 1, 2 and 3 ...)
What should I do to make all them visible again?
Thanks

 

[JLGWhiz]

Tools>Options>View then check the box for Row & Column Header

 

[JLGWhiz]

If you want the code syntax it is:

ActiveWindow.DisplayHeadings = True

 

[Jacob Skaria]

Tools>Options>View tab>Under windows options check 'Row and column headers'
and 'Sheet tabs'

If this post helps click Yes

 

[Elton Law]

Hi,
I have tried, but sheet tabs are still invisbile. Is it due to VBA settings?
I have used alt+F11 ans see.
Under Alphabetic, each sheet I have choosen to Enable Selection =
0-XlNoRestrictions.
Do you know what should I do now?
Thanks

 

[Jacob Skaria]

--Check the 'Visible' property of the sheet tab.
--Check whether there is any code placed in Workbook Open/BeforeClose events

If this post helps click Yes

 

[Elton Law]

I have checkec.
Still cannot make it.
Anyway, thanks for help. I decide to give up.
Thanks

 

[OssieMac]

If you are using xl2007 then in Help type in the following in the search field.

Where are my worksheet tabs

then follow the instructions and see if that works.

 

[JLGWhiz]

Put this macro in the public module of the workbook with the lost headings
and then run it.
If the headings do not appear after you run the macro, you have a real
problem.

Sub RestoreToNorm()
With Worksheets(2)
Do Until .Shapes.Count = 0
.Shapes(.Shapes.Count).Delete
Loop
.Cells.Clear
.Columns.UseStandardWidth = True
.Rows.UseStandardHeight = True
End With
With Application
.DisplayFullScreen = False
.DisplayFormulaBar = True
.DisplayStatusBar = True
End With
With ActiveWindow 'This with statement sets everything to normal
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
.DisplayHeadings = True
.DisplayGridlines = True
End With
ThisWorkbook.Save
End Sub