View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Otto1939 Otto1939 is offline
external usenet poster
 
Posts: 3
Default lost tabs for Sheet1, Sheet2....


thank you Conan.

I should have mentioned:

I am using Excel 2007 SP2, Windows XP SP3...the macro was not changed: also,
it does not hide/unhide the tabs.

I cannot apply your answer to Excel 2007, so I still do not know what
happened.

Otto


"Conan Kelly" wrote:

Otto1939,

Try (XL 2003 and prior, I'm not familiar with XL 2007):

Tools Options "View" tab "Window options" section
Verify "Sheet tabs" is checked

I don't know if there is a keyboard shortcut to turn these off, but it could
have been done with code.

HTH,

Conan Kelly





"Otto1939" wrote in message
...
I have a spreadsheet with several sheets. There is also a macro. When I
answer the macro security option question "enable this content", the tabs
for sheet1 ... used to appear at the bottom of the window. Now they does
not... I must have done something... I can still display the next sheet
by
pressing 'CTRL and PgDn'.

Anybody knows what I did and how to undo it?

Thanks you.