| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change color of Tab
HI,
I want to change the color of selected Tab at run time. With static Excel Sheet I know I can select the Tab(Sheet NAme), right click on it and change the color. But how can i do the same thing programatically? Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change color of Tab
Try recording a macro while doing it manually, and you have it.
HTH. Best wishes Harald "Sumesh" skrev i melding ... HI, I want to change the color of selected Tab at run time. With static Excel Sheet I know I can select the Tab(Sheet NAme), right click on it and change the color. But how can i do the same thing programatically? Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change color of Tab
Try something like
ActiveSheet.Tab.ColorIndex = 3 'red -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Sumesh" wrote in message ... HI, I want to change the color of selected Tab at run time. With static Excel Sheet I know I can select the Tab(Sheet NAme), right click on it and change the color. But how can i do the same thing programatically? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
| change fill color of a range of cells based on color of a cell? | Excel Programming | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Allow users to change the color of the comment indicator color so. | Excel Discussion (Misc queries) | |||
| Browse Forms Controls and change TextBox color based on cell color | Excel Programming | |||
Linear Mode
