| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column, Row and Sheet tab are gone
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column, Row and Sheet tab are gone
ToolsOptionsView then check the box for Row & Column Header
"Elton Law" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column, Row and Sheet tab are gone
If you want the code syntax it is:
ActiveWindow.DisplayHeadings = True "Elton Law" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column, Row and Sheet tab are gone
ToolsOptionsView tabUnder 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column, Row and Sheet tab are gone
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: ToolsOptionsView tabUnder 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column, Row and Sheet tab are gone
--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: ToolsOptionsView tabUnder 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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column, Row and Sheet tab are gone
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: ToolsOptionsView tabUnder 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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column, Row and Sheet tab are gone
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: ToolsOptionsView tabUnder 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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Column, Row and Sheet tab are gone
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" wrote in message ... 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: ToolsOptionsView tabUnder 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare sheet 1 column A numbers with sheet 2 column A number | Excel Worksheet Functions | |||
| Formula if Column E in Sheet 1 equals Column M in sheet 2, = Colum | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
| How to record a sheet change showing row column sheet name and date? | Excel Programming | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
