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 then check the box for Row & Column Header


"Elton Law" <(E-Mail Removed)> wrote in message
news:8E224CF8-5295-42AD-AE1D-(E-Mail Removed)...
> 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

If you want the code syntax it is:

ActiveWindow.DisplayHeadings = True




"Elton Law" <(E-Mail Removed)> wrote in message
news:8E224CF8-5295-42AD-AE1D-(E-Mail Removed)...
> 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
---------------
Jacob Skaria


"Elton Law" wrote:

> 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

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" wrote:

> Tools>Options>View tab>Under windows options check 'Row and column headers'
> and 'Sheet tabs'
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Elton Law" wrote:
>
> > 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

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


"Elton Law" wrote:

> 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" wrote:
>
> > Tools>Options>View tab>Under windows options check 'Row and column headers'
> > and 'Sheet tabs'
> >
> > If this post helps click Yes
> > ---------------
> > Jacob Skaria
> >
> >
> > "Elton Law" wrote:
> >
> > > 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

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

"Jacob Skaria" wrote:

> --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
> ---------------
> Jacob Skaria
>
>
> "Elton Law" wrote:
>
> > 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" wrote:
> >
> > > Tools>Options>View tab>Under windows options check 'Row and column headers'
> > > and 'Sheet tabs'
> > >
> > > If this post helps click Yes
> > > ---------------
> > > Jacob Skaria
> > >
> > >
> > > "Elton Law" wrote:
> > >
> > > > 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

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.

--
Regards,

OssieMac


"Elton Law" wrote:

> I have checkec.
> Still cannot make it.
> Anyway, thanks for help. I decide to give up.
> Thanks
>
> "Jacob Skaria" wrote:
>
> > --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
> > ---------------
> > Jacob Skaria
> >
> >
> > "Elton Law" wrote:
> >
> > > 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" wrote:
> > >
> > > > Tools>Options>View tab>Under windows options check 'Row and column headers'
> > > > and 'Sheet tabs'
> > > >
> > > > If this post helps click Yes
> > > > ---------------
> > > > Jacob Skaria
> > > >
> > > >
> > > > "Elton Law" wrote:
> > > >
> > > > > 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

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



"Elton Law" <(E-Mail Removed)> wrote in message
news:F97AC1F7-76CE-457A-9FAB-(E-Mail Removed)...
>I have checkec.
> Still cannot make it.
> Anyway, thanks for help. I decide to give up.
> Thanks
>
> "Jacob Skaria" wrote:
>
>> --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
>> ---------------
>> Jacob Skaria
>>
>>
>> "Elton Law" wrote:
>>
>> > 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" wrote:
>> >
>> > > Tools>Options>View tab>Under windows options check 'Row and column
>> > > headers'
>> > > and 'Sheet tabs'
>> > >
>> > > If this post helps click Yes
>> > > ---------------
>> > > Jacob Skaria
>> > >
>> > >
>> > > "Elton Law" wrote:
>> > >
>> > > > 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