Posted to microsoft.public.excel.programming

Minitman[_4_] Minitman[_4_] is offline

external usenet poster

Posts: 273

Changing Tab Color With VBA

Greetings,

I am running a macro to copy the formats of one sheet to the next
sheet. One of the formats that I need to copy is the tab color. I
have the macro recorders code but it is for a specific sheet

Sheets("Jun-94").Select
ActiveWorkbook.Sheets("Jun-94").Tab.ColorIndex = 53

Anyone have an idea as to how to charge it for the current sheet?

As always TIA

-Minitman

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Changing Row Color	Gs	Excel Discussion (Misc queries)	13	September 3rd 09 03:39 AM
changing the color of a cell	zhj23	Excel Discussion (Misc queries)	6	December 1st 07 03:09 AM
Changing color of a row	David G[_2_]	Excel Discussion (Misc queries)	3	July 20th 07 09:12 PM
Changing color in color palette	Dave Peterson	Setting up and Configuration of Excel	0	December 12th 04 02:39 PM
changing bg color	kraft	Excel Programming	2	April 1st 04 06:08 PM

All times are GMT +1. The time now is 08:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us