Multiform Tab Colours
 

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.

:)


--
Shake
------------------------------------------------------------------------
Shake's Profile: http://www.excelforum.com/member.php...o&userid=28577
View this thread: http://www.excelforum.com/showthread...hreadid=482554

Multiform Tab Colours
 

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


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=482554

Multiform Tab Colours
 

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!


--
Shake
------------------------------------------------------------------------
Shake's Profile: http://www.excelforum.com/member.php...o&userid=28577
View this thread: http://www.excelforum.com/showthread...hreadid=482554

Multiform Tab Colours
 

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

Multiform Tab Colours
 

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

--
Regards,
Tom Ogilvy


"Leith Ross" wrote
in message ...

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