Column, Row and Sheet tab are gone

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

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
 
Tools>Options>View tab>Under windows options check 'Row and column headers'
and 'Sheet tabs'

If this post helps click Yes
 
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
 
--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
 
I have checkec.
Still cannot make it.
Anyway, thanks for help. I decide to give up.
Thanks
 
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.
 
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
 
Back
Top