View Single Post
  #4  
Old February 21st, 2006, 03:45 AM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

Hi Tom,
Remove the s on the end it should be
http://www.mvps.org/dmcritchie/excel/template.htm

Firefox has an option to hide the tabs if there is only one, it is not something
that I could stand though Excel might not be as bad with the tabs at the bottom.

Rather than setting up templates why not set up a macro like this to turn them
on or off. You check the number of tabs and refuse to hide them if the
worksheet count is greater than one. You could even use event macros,
but all of this is something I would not want for myself. Perhaps your screen
resolution is too low. You could reduce the zoom down from 100% though
things work best if you keep it at 100%.

You can install the following macro (install in your personal.xls)
http://www.mvps.org/dmcritchie/excel/getstarted.htm
and invoke it from a menu, or on a toolbar button
http://www.mvps.org/dmcritchie/excel/toolbarsl.htm


Sub Macro23_toggle()
With ActiveWindow
If .DisplayHorizontalScrollBar = True AND _
worksheet.count 1 then
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
Else
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
End If
End With
End Sub

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Tom Russell" wrote in message ...
Hi David

Thank you for correctly analyzing what I wanted to do and for offering a
solution. Working with templates is something I have not gotten into before
so I will try it earlier in the day when the brain cells are more willing to
tackle a new project.

"If you hide the sheet names in all new workbooks what means are you using
to see your worksheet tabs and to change between them?"

I want to hide sheet tabs in workbooks that have only 1 sheet. When there
are multiple sheets, I leave them visible on the bottom of the sheet. To
add, change name, or delete sheet tabs I right click on them and follow the
pop up menu. Perhaps I will try to create multiple templates if that is
possible.

I am unable to open this link
http://www.mvps.org/dmcritchie/excel/templates.htm

These links open http://www.mvps.org/dmcritchie/excel/excel.htm
http://www.mvps.org/dmcritchie/excel/search.htm

Thank you again for your help and for directing me to some very worthwhile
reading material.