In Excel : can the sheet (page) tab colurs be changed from grey ?

Question

Can the back ground colour of Form (macro) buttons be changed ?
Can the colour page tabs, at he bottom of the work sheets, be changed ?

I don't have 2002 so the right click on TABS does not work

I have Excel 2000 so I KNOW now that the dab colours can not be changed

Answer 1

select. right click. format cells. patterns
select. right click. tab color.

Answer 2

Both Tab and macro button colors can be changed:

Tab:
1. Right click Sheet's tab.
2. Click "Tab Color..."
3. Choose Color. Hit Ok.

Form Macro Button.
1. Open the VBA toolbar
(To do this right click in the gray space by your standard and formatting toolbars. Chose the "Visual Basic" toolbar.)
2. Click the "Design Mode" button. (2nd button from the right). This will allow you to edit objects.
3. Right click the button which background you'd like to change.
4. Click Properties.
5. "BackColor" is the property for background color. Select drop down arrow next to the value and choose from the palette of colors available.

Answer 3

Hi,

To change the colour of the tab in excel just right click on one of the tabs and choose the option select all sheets and then again right click on the tab and select tab colour option and change the colour

Regards,
Prabhakar Vadlamani

Answer 4

Strayinma is correct on both counts. However, if you want to change the color of all of the tabs at once, Prabhakar Vadlamani has the best answer for that.

Answer 5

Right click the tab and select Tab Color and choose a color.

Answer 6

Try this

http://www.annoyances.org/exec/show/article02-122