A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sheet tabs and scroll bars



 
 
Thread Tools Display Modes
  #1  
Old February 20th, 2006, 02:16 AM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

It would be nice to have the option of eliminating sheet tabs and scroll bars
from new Excel workbook sheets. If this option already exists, I haven’t
found it yet. Thank you



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup
  #2  
Old February 20th, 2006, 03:55 PM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

Hi Tom,
How to hide scrollbars and sheet tabs on new workbooks.

Sounds like you already know how to hide them (tools, options, view), so what you need
to do is create a book.xlt workbook as a template with your workbook options
changed as desired.

If you also want to change defaults for worksheets you would also create a Sheet.xlt
workbook as a template with a single sheet changed to your defaults, and for new workbooks
you would change each sheet (typically 3) in your book.xlt.

Store your templates in your XLStart
folder, in the Microsoft Excel folder, or the alternate startup folder.

http://www.mvps.org/dmcritchie/excel/templates.htm

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.

The next chapter is on how Harry broke his own fingers to reduce accidentally hitting
the wrong keys.
---
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" Tom wrote in message ...
It would be nice to have the option of eliminating sheet tabs and scroll bars
from new Excel workbook sheets. If this option already exists, I haven't
found it yet. Thank you



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...ic.excel.setup


  #3  
Old February 21st, 2006, 02:31 AM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

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.
  #4  
Old February 21st, 2006, 04: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.



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

This thread is an example where Google Groups is not posting the original question
when posted through Microsoft CDO (Communities).
http://groups.google.com/groups?thre...GP09.phx .gbl

If I ask for the thread through the original post, it is not found in Google
http://groups.google.com/groups?thre...0microsoft.com

If I ask for the thread through the original post, this way it will be available in this newsgroup
for about two months on the Microsoft newsservers. Looks like Google is picking up the
groups from another place, or Microsoft is messing up newsgroups when posted through
web access. You can see the original posting while still there with
news://msnews.microsoft.com/79259CF3...0microsoft.com
---
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" Tom wrote in message ...
It would be nice to have the option of eliminating sheet tabs and scroll bars
from new Excel workbook sheets. If this option already exists, I haven't
found it yet. Thank you



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...ic.excel.setup


  #6  
Old February 22nd, 2006, 12:43 AM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

Thanks again, David. I have not gotten into macros without help from my son
who does everything while dad watches in amazement. And he now lives 2
states away. Therefore I don’t have the foggiest idea where to start. But I
assume I have to copy what you wrote and past it somewhere, but where is that
somewhere? I don’t have a file titled “personal.xls” that I am aware of.
Would you have time to lead me through this? Now I have to go to the kitchen
and repair a dishwasher before I get in real trouble. I was able to open the
third link without the “s”.
  #7  
Old February 22nd, 2006, 04:45 AM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

Hi Tom,
See You can install the macro in your personal.xls
http://www.mvps.org/dmcritchie/excel/getstarted.htm

which has far more information than I would put into a reply.
---
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 ...
Thanks again, David. I have not gotten into macros without help from my son
who does everything while dad watches in amazement. And he now lives 2
states away. Therefore I don't have the foggiest idea where to start. But I
assume I have to copy what you wrote and past it somewhere, but where is that
somewhere? I don't have a file titled "personal.xls" that I am aware of.
Would you have time to lead me through this? Now I have to go to the kitchen
and repair a dishwasher before I get in real trouble. I was able to open the
third link without the "s".



  #8  
Old February 23rd, 2006, 02:08 AM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

David:

You posted: “This thread is an example where Google Groups is not posting
the original question when posted through Microsoft CDO (Communities).”

If you are referring to my posts not having a copy of previous posts, I
should mention that I deleted them.

Tom


"David McRitchie" wrote:

This thread is an example where Google Groups is not posting the original question
when posted through Microsoft CDO (Communities).
http://groups.google.com/groups?thre...GP09.phx .gbl

If I ask for the thread through the original post, it is not found in Google
http://groups.google.com/groups?thre...0microsoft.com

If I ask for the thread through the original post, this way it will be available in this newsgroup
for about two months on the Microsoft newsservers. Looks like Google is picking up the
groups from another place, or Microsoft is messing up newsgroups when posted through
web access. You can see the original posting while still there with
news://msnews.microsoft.com/79259CF3...0microsoft.com
---
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" Tom wrote in message ...
It would be nice to have the option of eliminating sheet tabs and scroll bars
from new Excel workbook sheets. If this option already exists, I haven't
found it yet. Thank you



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...ic.excel.setup



  #9  
Old February 23rd, 2006, 02:15 AM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

David:

I did copy and paste your suggested macro into a new workbook according to
instructions in “Getting Started with Macros and User Defined Functions” but
got an error message I can’t resolve. Maybe I will have better luck tomorrow.

Thanks again for your help.

Tom


"David McRitchie" wrote:

Hi Tom,
See You can install the macro in your personal.xls
http://www.mvps.org/dmcritchie/excel/getstarted.htm

which has far more information than I would put into a reply.
---
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 ...
Thanks again, David. I have not gotten into macros without help from my son
who does everything while dad watches in amazement. And he now lives 2
states away. Therefore I don't have the foggiest idea where to start. But I
assume I have to copy what you wrote and past it somewhere, but where is that
somewhere? I don't have a file titled "personal.xls" that I am aware of.
Would you have time to lead me through this? Now I have to go to the kitchen
and repair a dishwasher before I get in real trouble. I was able to open the
third link without the "s".




  #10  
Old February 23rd, 2006, 04:44 PM posted to microsoft.public.excel.setup
external usenet poster
 
Posts: n/a
Default Sheet tabs and scroll bars

Hi Tom,
If you could and did delete a message that would explain things, but
you can't delete messages and if you click on the news link or paste
it into your browser you will see that it is still there.
news://msnews.microsoft.com/79259CF3...0microsoft.com


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

You posted: "This thread is an example where Google Groups is not posting
the original question when posted through Microsoft CDO (Communities)."

If you are referring to my posts not having a copy of previous posts, I
should mention that I deleted them.

Tom


"David McRitchie" wrote:

This thread is an example where Google Groups is not posting the original question
when posted through Microsoft CDO (Communities).
http://groups.google.com/groups?thre...GP09.phx .gbl

If I ask for the thread through the original post, it is not found in Google
http://groups.google.com/groups?thre...0microsoft.com

If I ask for the thread through the original post, this way it will be available in this newsgroup
for about two months on the Microsoft newsservers. Looks like Google is picking up the
groups from another place, or Microsoft is messing up newsgroups when posted through
web access. You can see the original posting while still there with
news://msnews.microsoft.com/79259CF3...0microsoft.com
---
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" Tom wrote in message

...
It would be nice to have the option of eliminating sheet tabs and scroll bars
from new Excel workbook sheets. If this option already exists, I haven't
found it yet. Thank you



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.



http://www.microsoft.com/office/comm...ic.excel.setup





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show sheet tabs in Microsoft Excel Shenda Worksheet Functions 10 January 16th, 2006 04:39 PM
Sheet tabs are hidden...option is checked okamico General Discussion 4 January 12th, 2006 10:14 PM
Excel opens saved workbook without tabs or scroll bars showing? Dave W Franklin Worksheet Functions 1 May 11th, 2005 11:11 PM
multipage tabs scroll out of view. CSFunder Using Forms 2 February 8th, 2005 01:45 PM
tabs word 97 Jim Henderson New Users 0 April 25th, 2004 07:34 PM


All times are GMT +1. The time now is 09:50 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.