spreadsheet tab disappear

I

inungh

Spreadhsheet tab disappear when I select one of the spreadhsheet.

Are there any option or format to set the tab back on every
spreadsheet?


Your help is great appreicated,
 
G

Gord Dibben

All worksheet tabs are available when you open the workbook?

Select any worksheet tab and the rest disappear or all disappear?

Select a particular one and the rest disappear or all disappear?

Does this occur in all workbooks or just one workbook?


Gord Dibben MS Excel MVP
 
I

inungh

All worksheet tabs are available when you open the workbook?

Select any worksheet tab and the rest disappear or all disappear?

Select a particular one and the rest disappear or all disappear?

Does this occur in all workbooks or just one workbook?

Gord Dibben  MS Excel MVP







- Show quoted text -
Click to expand...

Thanks for the message,

All worksheet tabs are available when you open the workbook? Yes,

Select any worksheet tab and the rest disappear or all disappear? If
I select the one disappear then all tab disappear. If I select others
then all tabs are OK

Select a particular one and the rest disappear or all disappear? Yes,
select particular one all disappear

Does this occur in all workbooks or just one workbook? It only
happens one workbook.


Thanks again,
 
G

Gord Dibben

See inline answers.

Thanks for the message,

All worksheet tabs are available when you open the workbook? Yes,

Select any worksheet tab and the rest disappear or all disappear? If
I select the one disappear then all tab disappear. If I select others
then all tabs are OK
Click to expand...

A workbook must have at least one sheet visible at all times so they can't
all disappear unless the workbook is closed.
Select a particular one and the rest disappear or all disappear? Yes,
select particular one all disappear
Click to expand...

See above
Does this occur in all workbooks or just one workbook? It only
happens one workbook.
Click to expand...

You must have event code running in that workbook.

Right-click on the offending tab and "View Code" to see if anything there.


Gord
 
Top