I have some code in Excel 2007 and I want it to be compatable with 2003. How would I go about finding what the similar command is in 2003 which will create similar cell background colors to thisIs there a website that will give approximate matches?
.ThemeColor = xlThemeColorLight2 ' only 2007 .TintAndShade = 0.599993896298105 ' only 2007 And .Interior.ThemeColor = xlThemeColorAccent2 .Interior.TintAndShade = 0.599993896298105
Thanks in advance.
Last edited by ChemistB; 05-18-2011 at 04:58 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks