Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
OK, if you post the code you have sofar in the NG:
microsoft.public.vb.winapi and/or microsoft.public.vb.general.discussion then I am sure somebody will tell you how to set the background color. RBS "RAFAAJ2000" wrote in message ... Thanks Smissaert . No . I can't use a UserForm as I would need to reduce its Width to macth that of the underlying Worksheet Cell. Apparently, an XL Userform Width can't be reduced below a certain level even after removing its title bar, caption and changing other of its Styles. I have already tried doing this via various APIs but failed ! I hope I am wrong though in which case I would definitely use a UserForm for this instead of a Static Window. I can't beleive that such seemingly easy thing ie: Simply setting the BackColor of a Window programatically can be that difficult !!!! I hope someone knows the answer to this one. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help window setting workbook collapse | Excel Discussion (Misc queries) | |||
Setting the zoom size of a new window from 100% to 75% | Excel Discussion (Misc queries) | |||
Window setting | Setting up and Configuration of Excel | |||
Setting to Keep a Spreadsheet in Front Window | Excel Worksheet Functions | |||
What is the setting to have more than one Excel Window? | Setting up and Configuration of Excel |