Thread: VBA - Colored Tabs Excel 2000
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
gitcypher[_3_] gitcypher[_3_] is offline
external usenet poster
  
Posts: 1
Default VBA - Colored Tabs Excel 2000
Try

Sheetname.Tab.ColorIndex = #

Sheet Name is self explanitory
the # is the color index number. See the attached image

Attachment filename: colors.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=56422
--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote