Tab Control

cmbc · May 1st, 2002, 08:29 AM

Is there a way to change the text on a tab based on a formula in the worksheet and is there a way to color code tabs?

Iain Lewis · May 1st, 2002, 08:36 AM

Don't think you can change the colour of the tab, but to change the name use :

Worksheets("sheet1").Name = "new name"

Von Pookie · May 1st, 2002, 08:37 AM

You can only change the tab color in Lotus and the XP version of Excel. For excel, right-click on the tab, and color (or something along those lines) should be an option.

May 1st, 2002, 08:37 AM	#3
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	You can only change the tab color in Lotus and the XP version of Excel. For excel, right-click on the tab, and color (or something along those lines) should be an option. __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

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

May 1st, 2002, 08:29 AM	#1
cmbc New Member Join Date: Apr 2002 Posts: 1	Is there a way to change the text on a tab based on a formula in the worksheet and is there a way to color code tabs?

May 1st, 2002, 08:36 AM	#2
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Don't think you can change the colour of the tab, but to change the name use : Worksheets("sheet1").Name = "new name"