Change Tab Color

Parra · Apr 12th, 2002, 11:06 AM

I was wondering if it was possible to change the tab color. What I want to change is the bottom part of the worksheet where it says "sheet 1","sheet 2",etc. I want to color code the tabs.

Thanks

Mark O'Brien · Apr 12th, 2002, 11:17 AM

No.

I heard a rumour that Excel XP allows you to do this but XL97 and 2000 definitely don't do this.

Converting to Excel from Lotus are we? It was a nice feature in Lotus.

Parra · Apr 12th, 2002, 11:30 AM

Thanks for the info.

I was not converting from Lotus to Excel. I just thought it might be nice for management to get the report color coded.

Thanks

Mark O'Brien · Apr 12th, 2002, 11:47 AM

We just give our management colouring in books and edible crayons. It seems to work best.

Mudface · Apr 12th, 2002, 11:50 AM

Tried that with ours, they got sick after eating too many crayons and the CEO ended up in hospital with a paper cut.

Jack in the UK · Apr 12th, 2002, 11:52 AM

Ok gusy bar Lotus its XP Excel only i use all versions, and XP ONLY

i have seen code that will change E2000 tabs colours but i feel i fell childish idea and very silly, this i regret never saving or chasing as regardless of what i think other might see as good and better still enjoy, i say sorry ive let guys down, now i grap ALL i think good or poor regardless.

Please im sorry.. but E2000 the is code somewhere to do this im sure it calles and re jiggs registry and other settings... i cant recall more. sorry

Maybe a guru programmer can solve this one, lets hope so..

As to lotus to Excel convertion it like round peg suuare hole, and so on... not so simple and VBA wont work bar few commands...

Mark O'Brien · Apr 12th, 2002, 12:00 PM

Quote:

On 2002-04-12 10:50, Mudface wrote:
Tried that with ours, they got sick after eating too many crayons and the CEO ended up in hospital with a paper cut.

Upgrade their laptop to an Etch-a-Sketch then. Remember to show them how to "cold-boot" it. (Turn it upside down and shake) --Stolen shamlessly from Dilbert.

Jack in the UK · Apr 12th, 2002, 12:02 PM

mark

Etch-a-Sketch

They only draw cars boats planes and tanks!

whos that help?? can they draw drinkable beer cans... thats drink the contence you get me!

England have call Vinney Jones in for world cup

Parra · Apr 12th, 2002, 12:16 PM

Thanks for the good laugh, its always fun to laugh at management.

Mudface · Apr 12th, 2002, 12:35 PM

Mock them. Mock them all.

Apr 12th, 2002, 11:17 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	No. I heard a rumour that Excel XP allows you to do this but XL97 and 2000 definitely don't do this. Converting to Excel from Lotus are we? It was a nice feature in Lotus. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 12th, 2002, 11:47 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	We just give our management colouring in books and edible crayons. It seems to work best. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 12th, 2002, 11:52 AM	#6
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Ok gusy bar Lotus its XP Excel only i use all versions, and XP ONLY i have seen code that will change E2000 tabs colours but i feel i fell childish idea and very silly, this i regret never saving or chasing as regardless of what i think other might see as good and better still enjoy, i say sorry ive let guys down, now i grap ALL i think good or poor regardless. Please im sorry.. but E2000 the is code somewhere to do this im sure it calles and re jiggs registry and other settings... i cant recall more. sorry Maybe a guru programmer can solve this one, lets hope so.. As to lotus to Excel convertion it like round peg suuare hole, and so on... not so simple and VBA wont work bar few commands... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 12th, 2002, 12:02 PM	#8
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	mark Etch-a-Sketch They only draw cars boats planes and tanks! whos that help?? can they draw drinkable beer cans... thats drink the contence you get me! England have call Vinney Jones in for world cup __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 12th, 2002, 11:06 AM	#1
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	I was wondering if it was possible to change the tab color. What I want to change is the bottom part of the worksheet where it says "sheet 1","sheet 2",etc. I want to color code the tabs. Thanks

Apr 12th, 2002, 11:30 AM	#3
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	Thanks for the info. I was not converting from Lotus to Excel. I just thought it might be nice for management to get the report color coded. Thanks

Apr 12th, 2002, 11:50 AM	#5
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Tried that with ours, they got sick after eating too many crayons and the CEO ended up in hospital with a paper cut.

Apr 12th, 2002, 12:16 PM	#9
Parra Board Regular Join Date: Feb 2002 Location: Los Angeles, CA Posts: 752	Thanks for the good laugh, its always fun to laugh at management.

Apr 12th, 2002, 12:35 PM	#10
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Mock them. Mock them all.