View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ctaylor ctaylor is offline
external usenet poster
 
Posts: 5
Default I cannot review my named sheet tabs on my spreadsheet

A co-worker fixed it.
"Gary''s Student" wrote:

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.