View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
rjdrw rjdrw is offline
external usenet poster
 
Posts: 2
Default How do I set the default tab fill in excel?

Thanks, I use Autocad 80% of the day and the options in this changes the tab
color along with all the toolbars and menus. Would be nice to have this
happen in the future releases of excel.

"Gord Dibben" wrote:

The color of Tabs are determined by your Windows Color Scheme in Display
PropertiesAppearance.

You can, if using Excel 2002 or 2003, color the tabs by selecting all tabs and
right-click and "Tab Color".

To make this default, you could create a Template for all new workbooks.

Open a new workbook. Customize as you wish. FileSave
As Type: scroll down to Excel Template(*.XLT) and select. Name your workbook
"BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for FileNew or the Toolbar button FileNew

Do not use FileNew...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default InsertSheet.

More can be found on this in Help under "templates"(no quotes).

For second question.........I have not heard of a method of changing the default
on these.


Gord Dibben Excel MVP

On Tue, 29 Aug 2006 06:19:02 -0700, rjdrw
wrote:

I have a flat panel monitor and it is very hard to diferentiate what tabs I
have selected by holding down shift or control and what are not selected for
a multiply copy, move, delete, etc. I would like to change the default tab
fill to a darker grey but cannot seem to find this anywhere. Also, changing
the angle of how I veiw the monitor does not help as the top of the screen
then is darker. Any help would be appreciated.


Gord Dibben MS Excel MVP