Multiform Tab Colours

[Shake]

Someone somewhere must know the code to change the grey tabs in a multiform to a different colour. Or even let my background picture cover all the tabs. Grey is not the colour of the future.

[dominicb]

Good morning Shake

You could try using this code - don't know if it's quite what you're looking for but they seem to be the only colour options available for the multipage control. The code, of course, assumes that your multipage is called MultiPage1 and needs to be inserted into your UserForm_Initialize routine.

MultiPage1.BackColor = RGB(64, 0, 0)
MultiPage1.ForeColor = RGB(255, 0, 0)

HTH

DominicB

[Shake]

Thanks DominicB, I does change the colour of the form next to the Tabs. However the Tabs stay Grey.

Is this one of those things that seems like it should be simple but is actualy a nightmare to try and change?

Maybe Tabs just need to be Grey!

[Leith Ross]

Hello Shake,

I wanted to change the tab color on a MultiPage sometime ago. I thought if all else failed it could be done using the API, but to do that one needs the window handle of the object. Unfortunately that isn't available directly through VBA. So on and so forth...I think in this case it is WYSIWYG. Would be nice to change the colors though.

Sincerely,
Leith Ross

[Tom Ogilvy]

Just to affirm:
MSForms controls are windowless controls. So the API won't work.

--
Regards,
Tom Ogilvy


"Leith Ross" <[email protected]> wrote
in message news:[email protected]...
>
> Hello Shake,
>
> I wanted to change the tab color on a MultiPage sometime ago. I thought
> if all else failed it could be done using the API, but to do that one
> needs the window handle of the object. Unfortunately that isn't
> available directly through VBA. So on and so forth...I think in this
> case it is WYSIWYG. Would be nice to change the colors though.
>
> Sincerely,
> Leith Ross
>
>
> --
> Leith Ross
> ------------------------------------------------------------------------
> Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
> View this thread: http://www.excelforum.com/showthread...hreadid=482554
>