Consulting

Results 1 to 7 of 7

Thread: Solved: Colour of multipage headers

  1. #1
    VBAX Regular
    Joined
    Dec 2008
    Posts
    86
    Location

    Smile Solved: Colour of multipage headers

    HI guys
    i have a multipage i want to change the headers of all the pages toa single colour. is there any possible way??
    [VBA]
    MultiPage1.BackColor=&H08943 'this doesn't work, it only changes the border colour of the headers, not the whole header.
    MultiPage.Forecolor=&H08943 ' this too doesnot work , it only chages the font colour.
    [/VBA]
    All the help is aappreciated.
    Regards,
    Kishlaya

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    The headers reflect the page/windows setting as I recall.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Dec 2008
    Posts
    86
    Location
    the page is actually inside a userform. but any idea which setting to change?
    Regards,
    Kishlaya

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    What I am saying is that I don't believe that you can without changing the windows settings which will affect loads of things.

    The multipage only has a backcolor and forecolor properts, neither of which change the page colour, and page has no colour properties. No very useful I agree, but there it is.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Regular
    Joined
    Dec 2008
    Posts
    86
    Location
    the colour of the body of the page i changed by putting a label on it and changing the colour , but now i need the tab headings to be changed to a different colour. i am not able to put a lable of the tab header.
    any other way to do it?

  6. #6
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Yeah, but that is frigging it, it isn't really changing the page, and as you have seen you can put a label on the tab header.

    I honestly believe that you cannot do what you are trying to do. I am sorry, and I agree it is a real omission, but it is not going to be fixed in VBA that is for sure.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  7. #7
    VBAX Regular
    Joined
    Dec 2008
    Posts
    86
    Location
    i guess you are right
    thanks anyways for the guidance
    Regards,
    Kishlaya

Posting Permissions

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