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

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

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

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

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

Sheet name is not visiable.
 

thank you all of you.....