I am building a 3 tab page User Form to get user input on pulling historical
data from another file. I noticed I can control the background color of the
User Form but cannot seem to control the colors of the Tab/Pages (the
multipages within the User Form). Anyone ever tried to do this before or
know how via code?

Sincerely,

Bryan

To the best of my knowledge, control of this setting is not surrendered.

--
Regards,
Tom Ogilvy


"Bryan44" wrote in message
...
I am building a 3 tab page User Form to get user input on pulling
historical
data from another file. I noticed I can control the background color of
the
User Form but cannot seem to control the colors of the Tab/Pages (the
multipages within the User Form). Anyone ever tried to do this before or
know how via code?

Sincerely,

Bryan

Some workarounds I have seen suggested is to use multiple frames instead of
a multipage. You can color the frames. Then use the frames to simulate a
multipage.


Another was to hide the tabs and use buttons or labels (which can be
colored) to simulate the tabs. This would only color the "tabs".

Also if you just want to color the page (not the tab), you can put in a
small colored bitmap on each page and tile it.

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
To the best of my knowledge, control of this setting is not surrendered.

--
Regards,
Tom Ogilvy


"Bryan44" wrote in message
...
I am building a 3 tab page User Form to get user input on pulling
historical
data from another file. I noticed I can control the background color of
the
User Form but cannot seem to control the colors of the Tab/Pages (the
multipages within the User Form). Anyone ever tried to do this before or
know how via code?

Sincerely,

Bryan

Tom,

Thank you very much! I didn't think of that and that surely helps.

Bryan

"Tom Ogilvy" wrote:

Some workarounds I have seen suggested is to use multiple frames instead of
a multipage. You can color the frames. Then use the frames to simulate a
multipage.


Another was to hide the tabs and use buttons or labels (which can be
colored) to simulate the tabs. This would only color the "tabs".

Also if you just want to color the page (not the tab), you can put in a
small colored bitmap on each page and tile it.

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
To the best of my knowledge, control of this setting is not surrendered.

--
Regards,
Tom Ogilvy


"Bryan44" wrote in message
...
I am building a 3 tab page User Form to get user input on pulling
historical
data from another file. I noticed I can control the background color of
the
User Form but cannot seem to control the colors of the Tab/Pages (the
multipages within the User Form). Anyone ever tried to do this before or
know how via code?

Sincerely,

Bryan