spreadsheet tab disappear

  • Thread starter Thread starter inungh
  • Start date Start date
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,
 
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
 
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,
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top