Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color in Multipage Form
Hi all,
Is it possible to change the color in the multipage form, the "BackColor" does not show up in the properties and the color now is gray. Thanks. Gian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color in Multipage Form
Don't think so.
-- HTH RP (remove nothere from the email address if mailing direct) "Gian" wrote in message ... Hi all, Is it possible to change the color in the multipage form, the "BackColor" does not show up in the properties and the color now is gray. Thanks. Gian |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color in Multipage Form
The way to change the color is the use the Picture property of the page.
Here are the steps to do it. 1. Highlight cells A1:E11 on some sheet. Format the cells to have say a yellow background color.(not font) 2. Do a Control-C to copy the cells into memory. 3. Switch to the code window and select the form and within that the page you want to set the background color for. 4. Click on the picture property in the property window and do a Control-V. The text in the property will change to 'Bitmap' 5. Repeat for other pages in the Multi-page control. Alok "Gian" wrote: Hi all, Is it possible to change the color in the multipage form, the "BackColor" does not show up in the properties and the color now is gray. Thanks. Gian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MultiPage Form Question | Excel Discussion (Misc queries) | |||
multipage form | Excel Programming | |||
Multipage & Spinbutton controls on a form | Excel Programming | |||
Multipage Object on User Form | Excel Programming | |||
Can I set a page of a Multipage form to active? | Excel Programming |