Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet name is not visiable.
Hi,
I have a workbook in which I am not able to see the sheet names.(I mean tabs are not visiable.) I dont know what has gone worng. The workbook is not protected. I am using excel 2007. Regards Heera |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet name is not visiable.
Sorry I don't have XL2007 at hand to give exact directions, but select Office
Button Excel Options. I believe there is an option there to display sheet tabs (or not). Hope this helps, Hutch "Heera" wrote: Hi, I have a workbook in which I am not able to see the sheet names.(I mean tabs are not visiable.) I dont know what has gone worng. The workbook is not protected. I am using excel 2007. Regards Heera |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet name is not visiable.
Office ButtonExcel OptionsAdvanced.
Scroll down to "Display Options fro this workbook" Checkmark "Show Sheet Tabs" Gord Dibben MS Excel MVP On Wed, 25 Feb 2009 12:49:01 -0800, Heera wrote: Hi, I have a workbook in which I am not able to see the sheet names.(I mean tabs are not visiable.) I dont know what has gone worng. The workbook is not protected. I am using excel 2007. Regards Heera |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet name is not visiable.
Office button / Excel options (at bottom)
Advanced tab on left Display Options for this Workbook (5th group down) Show sheet tabs (3 rd item in group) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Heera" wrote in message ... Hi, I have a workbook in which I am not able to see the sheet names.(I mean tabs are not visiable.) I dont know what has gone worng. The workbook is not protected. I am using excel 2007. Regards Heera |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet name is not visiable.
Since you posted in the programming group perhaps you have event code behind
Thisworkbook module that hides those sheetnames when the book is opened? If that's the case, change the code........or delete it. Gord On Wed, 25 Feb 2009 13:10:24 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Office ButtonExcel OptionsAdvanced. Scroll down to "Display Options fro this workbook" Checkmark "Show Sheet Tabs" Gord Dibben MS Excel MVP On Wed, 25 Feb 2009 12:49:01 -0800, Heera wrote: Hi, I have a workbook in which I am not able to see the sheet names.(I mean tabs are not visiable.) I dont know what has gone worng. The workbook is not protected. I am using excel 2007. Regards Heera |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet name is not visiable.
thank you all of you.....
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Calculating Only Visiable Data | Excel Programming | |||
Validation Cell Always Visiable, with a default message in it... | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |