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