spreadsheet tab disappear

[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,

 

[Gary''s Student]

Tools > Options > View > Sheet tabs

 

[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

 

[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 -

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,

 

[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

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

See above

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

You must have event code running in that workbook.

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


Gord