Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 318
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MultiPage Form Question NFL Excel Discussion (Misc queries) 4 December 30th 09 02:21 PM
multipage form Sandy Excel Programming 1 May 6th 05 07:47 AM
Multipage & Spinbutton controls on a form Bhuktar S Excel Programming 1 April 21st 04 01:50 PM
Multipage Object on User Form Paul Cheers Excel Programming 2 November 27th 03 11:40 AM
Can I set a page of a Multipage form to active? John T Ingato Excel Programming 2 October 11th 03 12:15 AM


All times are GMT +1. The time now is 11:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"