MGumbrell
01-31-2006, 07:29 AM
Is it possible to change the colour of the tabs on a worksheet. If it is I would be grateful if you would let me know how.
Regards, Matt
Regards, Matt
|
View Full Version : Worksheet Tab Colour MGumbrell 01-31-2006, 07:29 AM Is it possible to change the colour of the tabs on a worksheet. If it is I would be grateful if you would let me know how. Regards, Matt qafself 01-31-2006, 07:49 AM Yes, matt, it's easy. Just right click on the tab and in the box select tab colour and off you go! Ed shades 01-31-2006, 05:35 PM As long as you have XL 2002 or 2003. Otherwise you need VBA code. HaHoBe 01-31-2006, 07:59 PM Hi, shades, Otherwise you need VBA code.Could you please post some sniplets to work in Windows for XL8 and/or XL9? TIA, Holger MGumbrell 02-01-2006, 12:52 AM Thanks guys. I don't have XL 2002 or 2003 so I would be very gratefulif you could tell me how to do it in VBA. Many Thanks, Matt shades 02-01-2006, 05:33 AM This is rather extreme, and it will change the system colors. So be warned! Change Tab Color in XL97 and XL 2000 (http://www.xcelfiles.com/Excel01_02.html) Not recommended! MGumbrell 02-01-2006, 06:13 AM I will take the warning and not use it, but many thanks anyway. Regards, Matt HaHoBe 02-01-2006, 10:03 AM Hi, shades, thanks for the link. Anyway I donīt come from from Lotus but had used Quattro Pro since the early beginnings in DOS with Borland - and that spreadsheet application featured coloured tabs from the very early (donīt remember if version 1.0 already featured it) Windows versions. Not to notice that version 2000 had some features that are due to come with Excel 12 - no comment if these are really necessary features (I really donīt think so as I havenīt handled files of that categories with a spreadsheet by now: Iīd prefer a DBMS). Ciao, Holger shades 02-01-2006, 11:06 AM I have mixed reaction to Excel 12. 1,000,000 rows and 64,000 columns. Might be okay, but just give people the idea it can become a database. The ribbon is less customizable than current toolbar approach, which I find frustrating. I began on the Mac, and still use the Mac at home (OS X with Office 2004), which has been highly customizable. But I customize both my Windows version (at work) and my Mac version. The improvements in Pivot Tables will be welcome. VBA will be critical from my standpoint, since the Mac version still is based on VB5 (essentially XL 97 equivalent). There are many things that I can do at work in VBA that cannot be done on the Mac (some can be done with AppleScript). And the list goes on.... |