ExcelBanter - Sheet Names Disappeared

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sheet Names Disappeared (https://www.excelbanter.com/excel-discussion-misc-queries/263799-sheet-names-disappeared.html)

terry

Sheet Names Disappeared

The sheet names disappeared....I went to Excel Options and they are turned on
for the WB and Sheets still they don't appear
HELP

Gary''s Student

Sheet Names Disappeared

Tools Options View and sure Sheet tabs is checked.
--
Gary''s Student - gsnu201003

"Terry" wrote:

The sheet names disappeared....I went to Excel Options and they are turned on
for the WB and Sheets still they don't appear
HELP

bala_vb

Quote:

Originally Posted by Terry (Post 953714)

The sheet names disappeared....I went to Excel Options and they are turned on
for the WB and Sheets still they don't appear
HELP

Use this simple vba code

Private Sub Workbook_Open()
ActiveWindow.DisplayWorkbookTabs = True
End Sub

all the best

Gord Dibben

Sheet Names Disappeared

Maybe they are just out of sight below?

Can you adjust the window size?

Has the horizontal slider bar been dragged all the way left?

Gord Dibben MS Excel MVP

On Fri, 14 May 2010 11:01:01 -0700, Terry
wrote:

The sheet names disappeared....I went to Excel Options and they are turned on
for the WB and Sheets still they don't appear
HELP

All times are GMT +1. The time now is 11:59 AM.