Sheet tabs and scroll bars

T

Tom Russell

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/com...-73080520345b&dg=microsoft.public.excel.setup
 
D

David McRitchie

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 said:
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/com...-73080520345b&dg=microsoft.public.excel.setup
 
T

Tom Russell

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.
 
D

David McRitchie

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
 
D

David McRitchie

This thread is an example where Google Groups is not posting the original question
when posted through Microsoft CDO (Communities).
http://groups.google.com/[email protected]

If I ask for the thread through the original post, it is not found in Google
http://groups.google.com/groups?threadm=79259CF3-4E58-4322-8575-73080520345B@microsoft.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-4E58-4322-8575-73080520345B%40microsoft.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 said:
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/com...-73080520345b&dg=microsoft.public.excel.setup
 
T

Tom Russell

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â€.
 
T

Tom Russell

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 said:
This thread is an example where Google Groups is not posting the original question
when posted through Microsoft CDO (Communities).
http://groups.google.com/[email protected]

If I ask for the thread through the original post, it is not found in Google
http://groups.google.com/groups?threadm=79259CF3-4E58-4322-8575-73080520345B@microsoft.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-4E58-4322-8575-73080520345B%40microsoft.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 said:
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/com...-73080520345b&dg=microsoft.public.excel.setup
 
T

Tom Russell

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 said:
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 said:
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".
 
D

David McRitchie

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-4E58-4322-8575-73080520345B%40microsoft.com


Tom Russell said:
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 said:
This thread is an example where Google Groups is not posting the original question
when posted through Microsoft CDO (Communities).
http://groups.google.com/[email protected]

If I ask for the thread through the original post, it is not found in Google
http://groups.google.com/groups?threadm=79259CF3-4E58-4322-8575-73080520345B@microsoft.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-4E58-4322-8575-73080520345B%40microsoft.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



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/com...-73080520345b&dg=microsoft.public.excel.setup
 
T

Tom Russell

The above post requires clarification by adding 3 words to the end (in bold
italics) as follows:

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 from my posts.

Tom
 
T

Tom Russell

David

It’s beginning to look like I am hopelessly over my head. I have been
working on it for over an hour and am not getting anywhere very fast. And my
bride is beginning to wonder or perhaps I should say she is continuing to
wonder about my sanity or lack of it. I printed everything from your links
that applies to setting up macros and plan to work on it again tomorrow.

Thanks for your patience and your help.

Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top