Change Tab Color
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Change Tab Color

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I was wondering if it was possible to change the tab color. What I want to change is the bottom part of the worksheet where it says "sheet 1","sheet 2",etc. I want to color code the tabs.

    Thanks

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No.

    I heard a rumour that Excel XP allows you to do this but XL97 and 2000 definitely don't do this.

    Converting to Excel from Lotus are we? It was a nice feature in Lotus.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the info.

    I was not converting from Lotus to Excel. I just thought it might be nice for management to get the report color coded.

    Thanks

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We just give our management colouring in books and edible crayons. It seems to work best.

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Tried that with ours, they got sick after eating too many crayons and the CEO ended up in hospital with a paper cut.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ok gusy bar Lotus its XP Excel only i use all versions, and XP ONLY

    i have seen code that will change E2000 tabs colours but i feel i fell childish idea and very silly, this i regret never saving or chasing as regardless of what i think other might see as good and better still enjoy, i say sorry ive let guys down, now i grap ALL i think good or poor regardless.

    Please im sorry.. but E2000 the is code somewhere to do this im sure it calles and re jiggs registry and other settings... i cant recall more. sorry

    Maybe a guru programmer can solve this one, lets hope so..

    As to lotus to Excel convertion it like round peg suuare hole, and so on... not so simple and VBA wont work bar few commands...
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-12 10:50, Mudface wrote:
    Tried that with ours, they got sick after eating too many crayons and the CEO ended up in hospital with a paper cut.
    Upgrade their laptop to an Etch-a-Sketch then. Remember to show them how to "cold-boot" it. (Turn it upside down and shake) --Stolen shamlessly from Dilbert.

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    mark

    Etch-a-Sketch

    They only draw cars boats planes and tanks!

    whos that help?? can they draw drinkable beer cans... thats drink the contence you get me!

    England have call Vinney Jones in for world cup

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the good laugh, its always fun to laugh at management.

  10. #10
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Mock them. Mock them all.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com