software

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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

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

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.

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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Tom Russellquot; lt;Tom gt; wrote in message ...
gt; It would be nice to have the option of eliminating sheet tabs and scroll bars
gt; from new Excel workbook sheets. If this option already exists, I haven't
gt; found it yet. Thank you
gt;
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
www.microsoft.com/office/comm...ic.excel.setup
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
www.mvps.org/dmcritchie/excel/templates.htm

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

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

Hi Tom,
Remove the s on the end it should be
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)
www.mvps.org/dmcritchie/excel/getstarted.htm
and invoke it from a menu, or on a toolbar button
www.mvps.org/dmcritchie/excel/toolbarsl.htmSub Macro23_toggle()
With ActiveWindow
If .DisplayHorizontalScrollBar = True AND _
worksheet.count gt; 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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Tom Russellquot; gt; wrote in message ...
gt; Hi David
gt;
gt; Thank you for correctly analyzing what I wanted to do and for offering a
gt; solution. Working with templates is something I have not gotten into before
gt; so I will try it earlier in the day when the brain cells are more willing to
gt; tackle a new project.
gt;
gt; quot;If you hide the sheet names in all new workbooks what means are you using
gt; to see your worksheet tabs and to change between them?quot;
gt;
gt; I want to hide sheet tabs in workbooks that have only 1 sheet. When there
gt; are multiple sheets, I leave them visible on the bottom of the sheet. To
gt; add, change name, or delete sheet tabs I right click on them and follow the
gt; pop up menu. Perhaps I will try to create multiple templates if that is
gt; possible.
gt;
gt; I am unable to open this link
gt; www.mvps.org/dmcritchie/excel/templates.htm
gt;
gt; These links open www.mvps.org/dmcritchie/excel/excel.htm
gt; www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; Thank you again for your help and for directing me to some very worthwhile
gt; reading material.
This thread is an example where Google Groups is not posting the original question
when posted through Microsoft CDO (Communities).
groups.google.com/groups?thre...GP09.phx .gbl

If I ask for the thread through the original post, it is not found in Google
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm
quot;Tom Russellquot; lt;Tom gt; wrote in message ...
gt; It would be nice to have the option of eliminating sheet tabs and scroll bars
gt; from new Excel workbook sheets. If this option already exists, I haven't
gt; found it yet. Thank you
gt;
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
www.microsoft.com/office/comm...ic.excel.setup
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”.

Hi Tom,
See You can install the macro in your personal.xls
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

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

Tomquot;David McRitchiequot; wrote:

gt; This thread is an example where Google Groups is not posting the original question
gt; when posted through Microsoft CDO (Communities).
gt; groups.google.com/groups?thre...GP09.phx .gbl
gt;
gt; If I ask for the thread through the original post, it is not found in Google
gt; groups.google.com/groups?thre...0microsoft.com
gt;
gt; If I ask for the thread through the original post, this way it will be available in this newsgroup
gt; for about two months on the Microsoft newsservers. Looks like Google is picking up the
gt; groups from another place, or Microsoft is messing up newsgroups when posted through
gt; web access. You can see the original posting while still there with
gt; news://msnews.microsoft.com/79259CF3...0microsoft.com
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt;
gt;
gt; quot;Tom Russellquot; lt;Tom gt; wrote in message ...
gt; gt; It would be nice to have the option of eliminating sheet tabs and scroll bars
gt; gt; from new Excel workbook sheets. If this option already exists, I haven't
gt; gt; found it yet. Thank you
gt; gt;
gt; gt;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt;
gt; www.microsoft.com/office/comm...ic.excel.setup
gt;
gt;
gt;

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.

Tomquot;David McRitchiequot; wrote:

gt; Hi Tom,
gt; See You can install the macro in your personal.xls
gt; www.mvps.org/dmcritchie/excel/getstarted.htm
gt;
gt; which has far more information than I would put into a reply.
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Tom Russellquot; gt; wrote in message ...
gt; gt; Thanks again, David. I have not gotten into macros without help from my son
gt; gt; who does everything while dad watches in amazement. And he now lives 2
gt; gt; states away. Therefore I don't have the foggiest idea where to start. But I
gt; gt; assume I have to copy what you wrote and past it somewhere, but where is that
gt; gt; somewhere? I don't have a file titled quot;personal.xlsquot; that I am aware of.
gt; gt; Would you have time to lead me through this? Now I have to go to the kitchen
gt; gt; and repair a dishwasher before I get in real trouble. I was able to open the
gt; gt; third link without the quot;squot;.
gt;
gt;
gt;

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.comquot;Tom Russellquot; gt; wrote in message ...
gt; David:
gt;
gt; You posted: quot;This thread is an example where Google Groups is not posting
gt; the original question when posted through Microsoft CDO (Communities).quot;
gt;
gt; If you are referring to my posts not having a copy of previous posts, I
gt; should mention that I deleted them.
gt;
gt; Tom
gt;
gt;
gt; quot;David McRitchiequot; wrote:
gt;
gt; gt; This thread is an example where Google Groups is not posting the original question
gt; gt; when posted through Microsoft CDO (Communities).
gt; gt; groups.google.com/groups?thre...GP09.phx .gbl
gt; gt;
gt; gt; If I ask for the thread through the original post, it is not found in Google
gt; gt; groups.google.com/groups?thre...0microsoft.com
gt; gt;
gt; gt; If I ask for the thread through the original post, this way it will be available in this newsgroup
gt; gt; for about two months on the Microsoft newsservers. Looks like Google is picking up the
gt; gt; groups from another place, or Microsoft is messing up newsgroups when posted through
gt; gt; web access. You can see the original posting while still there with
gt; gt; news://msnews.microsoft.com/79259CF3...0microsoft.com
gt; gt; ---
gt; gt; HTH,
gt; gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Tom Russellquot; lt;Tom gt; wrote in message
...
gt; gt; gt; It would be nice to have the option of eliminating sheet tabs and scroll bars
gt; gt; gt; from new Excel workbook sheets. If this option already exists, I haven't
gt; gt; gt; found it yet. Thank you
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; ----------------
gt; gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; gt; click quot;I Agreequot; in the message pane.
gt; gt; gt;
gt; gt; gt;
gt; gt;
www.microsoft.com/office/comm...ic.excel.setup
gt; gt;
gt; gt;
gt; gt;