XL2003 and tab colours "Jack Sheet" <no-one[ at ]nowhere.com> 12.08.2006 15:52:58 I have started using XL2003 after some years' experience with earlier versions. On the latest version the background colour of the worksheet tabs is white in the case of selected (or grouped) sheets, but very very very light grey in the case of unselected sheets. This makes it hard to see which worksheets are selected or included in the group. Is there a way to customise this, please?

Re: XL2003 and tab colours oldchippy <oldchippy.2cfpys_1155399009.0902[ at ]excelforum-nospam.com> 12.08.2006 16:08:07 Jack Sheet Wrote: > I have started using XL2003 after some years' experience with earlier [Quoted Text] > versions. On the latest version the background colour of the worksheet > tabs > is white in the case of selected (or grouped) sheets, but very very > very > light grey in the case of unselected sheets. This makes it hard to > see > which worksheets are selected or included in the group. Is there a way > to > customise this, please? Hi Jack Sheet, Try right clicking on the tab and change the colour. Is this any better? oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=19907 View this thread: http://www.excelforum.com/showthread.php?threadid=571046

Re: XL2003 and tab colours Gord Dibben <gorddibbATshawDOTca> 12.08.2006 16:58:31 Jack Select all sheets and right-click on a tab and "color tabs". Choose a darker gray or any color you wish to give more contrast with the Grouped sheets which will still show up as white". You could create a Template named Book.xlt with the sheet tabs color as you wish. This would not affect existing workbooks. Gord Dibben MS Excel MVP On Sat, 12 Aug 2006 16:52:58 +0100, "Jack Sheet" <no-one[ at ]nowhere.com> wrote: [Quoted Text] >I have started using XL2003 after some years' experience with earlier >versions. On the latest version the background colour of the worksheet tabs >is white in the case of selected (or grouped) sheets, but very very very >light grey in the case of unselected sheets. This makes it hard to see >which worksheets are selected or included in the group. Is there a way to >customise this, please? >

Re: XL2003 and tab colours "Jack Sheet" <no-one[ at ]nowhere.com> 12.08.2006 19:58:03 Thanks Gord - and oldchippy - I never think of right clicking. How do I set the default colours for a new workbook (or for new worksheets inserted into a workbook)? "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:av1sd2dtm21lbg3eoa2i906g93isbiia32[ at ]4ax.com... [Quoted Text] > Jack > > Select all sheets and right-click on a tab and "color tabs". > > Choose a darker gray or any color you wish to give more contrast with the > Grouped sheets which will still show up as white". > > You could create a Template named Book.xlt with the sheet tabs color as > you > wish. > > This would not affect existing workbooks. > > > Gord Dibben MS Excel MVP > > On Sat, 12 Aug 2006 16:52:58 +0100, "Jack Sheet" <no-one[ at ]nowhere.com> > wrote: > >>I have started using XL2003 after some years' experience with earlier >>versions. On the latest version the background colour of the worksheet >>tabs >>is white in the case of selected (or grouped) sheets, but very very very >>light grey in the case of unselected sheets. This makes it hard to see >>which worksheets are selected or included in the group. Is there a way to >>customise this, please? >> >

Re: XL2003 and tab colours Gord Dibben <gorddibbATshawDOTca> 12.08.2006 21:27:36 Jack Open a new workbook. Customize your sheet tabs as you wish. File>Save 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 File>New or the Toolbar button File>New Do not use File>New...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 Insert>Sheet. More can be found on this in Help under "templates"(no quotes). Gord Dibben Excel MVP On Sat, 12 Aug 2006 20:58:03 +0100, "Jack Sheet" <no-one[ at ]nowhere.com> wrote: [Quoted Text] >Thanks Gord - and oldchippy - I never think of right clicking. How do I set >the default colours for a new workbook (or for new worksheets inserted into >a workbook)? > >"Gord Dibben" <gorddibbATshawDOTca> wrote in message >news:av1sd2dtm21lbg3eoa2i906g93isbiia32[ at ]4ax.com... >> Jack >> >> Select all sheets and right-click on a tab and "color tabs". >> >> Choose a darker gray or any color you wish to give more contrast with the >> Grouped sheets which will still show up as white". >> >> You could create a Template named Book.xlt with the sheet tabs color as >> you >> wish. >> >> This would not affect existing workbooks. >> >> >> Gord Dibben MS Excel MVP >> >> On Sat, 12 Aug 2006 16:52:58 +0100, "Jack Sheet" <no-one[ at ]nowhere.com> >> wrote: >> >>>I have started using XL2003 after some years' experience with earlier >>>versions. On the latest version the background colour of the worksheet >>>tabs >>>is white in the case of selected (or grouped) sheets, but very very very >>>light grey in the case of unselected sheets. This makes it hard to see >>>which worksheets are selected or included in the group. Is there a way to >>>customise this, please? >>> >> > Gord Dibben MS Excel MVP

Re: XL2003 and tab colours "Jack Sheet" <no-one[ at ]nowhere.com> 13.08.2006 07:57:31 Thanks very much Gord "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:oshsd2le8kgnlk6c1m4l4l54kq4adq0s37[ at ]4ax.com... [Quoted Text] > Jack > > Open a new workbook. Customize your sheet tabs as you wish. File>Save > 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 File>New or the Toolbar button > File>New > > Do not use File>New...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 Insert>Sheet. > > More can be found on this in Help under "templates"(no quotes). > > > Gord Dibben Excel MVP > > > On Sat, 12 Aug 2006 20:58:03 +0100, "Jack Sheet" <no-one[ at ]nowhere.com> > wrote: > >>Thanks Gord - and oldchippy - I never think of right clicking. How do I >>set >>the default colours for a new workbook (or for new worksheets inserted >>into >>a workbook)? >> >>"Gord Dibben" <gorddibbATshawDOTca> wrote in message >>news:av1sd2dtm21lbg3eoa2i906g93isbiia32[ at ]4ax.com... >>> Jack >>> >>> Select all sheets and right-click on a tab and "color tabs". >>> >>> Choose a darker gray or any color you wish to give more contrast with >>> the >>> Grouped sheets which will still show up as white". >>> >>> You could create a Template named Book.xlt with the sheet tabs color as >>> you >>> wish. >>> >>> This would not affect existing workbooks. >>> >>> >>> Gord Dibben MS Excel MVP >>> >>> On Sat, 12 Aug 2006 16:52:58 +0100, "Jack Sheet" <no-one[ at ]nowhere.com> >>> wrote: >>> >>>>I have started using XL2003 after some years' experience with earlier >>>>versions. On the latest version the background colour of the worksheet >>>>tabs >>>>is white in the case of selected (or grouped) sheets, but very very very >>>>light grey in the case of unselected sheets. This makes it hard to see >>>>which worksheets are selected or included in the group. Is there a way >>>>to >>>>customise this, please? >>>> >>> >> > > Gord Dibben MS Excel MVP