View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default spreadsheet tab disappear

See inline answers.

On Thu, 18 Dec 2008 04:24:57 -0800 (PST), inungh wrote:

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