Microsoft KB Archive/929998

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 18:35, 18 July 2020 by 3155ffGd (talk | contribs) (importing KB archive)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Knowledge Base


Objects may be different colors when you use Visual Basic for Applications to set more than one object to the same color in Excel 2007

Article ID: 929998

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Excel 2007



SYMPTOMS

When you use Visual Basic for Applications (VBA) to set more than one object to the same color in Microsoft Office Excel 2007, some of those objects may be different colors. This problem occurs when you use the SchemeColor variable and the ThemeColor variable to set the color of the objects in VBA.

WORKAROUND

To work around this problem, use RGB settings to set the color of objects in VBA.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Additional query words: xl2007

Keywords: kbtshoot kbprb kbexpertisebeginner KB929998