View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default I cannot review my named sheet tabs on my spreadsheet

If you right-click where the tabs used to be and you see a bunch of scroll
and page options, that's it.

You can un-do it by carefully grabbing the end of the scroll bar and
manually shortening it or by running this one-line macro:

Sub get_those_tabs_back()
ActiveWindow.TabRatio = 0.75
End Sub
--
Gary's Student


"ctaylor" wrote:

How do I check that?

"Gary''s Student" wrote:

Make sure the horizontal scroll bar has not been overly lengthened.
--
Gary's Student


"ctaylor" wrote:

I have an excel spreadsheet w/named sheet tabs. I am not able to view them. i
have done something to the spreadsheet. There is nothing to unhide and i have
checked the TOOLS, OPTIONS, VIEW and the appropriate boxes are checked.