Thread: Tab color?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default Tab color?

When I set Tab Color, it only puts an underscore of the selected color under
the sheet name.

I would like to change the background color of the tab -- ideally even the
font style and color of the tab name.

Can any of that be done?

I suspect not because when I do Record Macro while renaming a tab and
changing tab color, the normally VBA code is uncharacteristically succinct,
revealing nothing more being done than I can already see, setting only .Name
and .Tab.ColorIndex.