ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Color in Multipage Form (https://www.excelbanter.com/excel-programming/338175-color-multipage-form.html)

Gian

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

Bob Phillips[_6_]

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




Alok

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



All times are GMT +1. The time now is 01:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com