| View previous topic :: View next topic |
| Author |
Message |
jeffkan1
General User
Joined: 14 Sep 2010
Posts: 10
Location: Kansas, USA
|
 Posted: Mon Dec 20, 2010 2:51 pm Post subject: Wrong color is appearing |
 |
|
I've got the below lines of code, one displays the correct color and one doesn't. Any ideas?
This sub displays gray as desired:
| Code: | Sub ChangeCellGrey(CellToColor)
CellToColor.CellBackColor = RGB(187, 187, 187) ' grey gray |
This sub displays a golden yellow color, but it's supposed to be cyan (or a turquoise blue):
| Code: | Sub ChangeCellColorBlue(CellToColor2)
CellToColor2.CellBackColor = RGB(0, 197, 223) ' turquoise blue |
In my first Symphony spreadsheet and writing Basic macros, the RGB function performed simply and as expected. Now I'm in my second Symphony spreadsheet and for some reason, what's supposed to be cyan is golden yellow.
I use the following website to see instantly what color the various numbers for RGB produce. http://www.masstraffic.com/java/rgb-slider.html Thanks!
_________________
Jeff |
|
| Back to top |
|
 |
hanya
Super User
Joined: 04 May 2005
Posts: 543
Location: Japan
|
| Posted: Mon Dec 20, 2010 6:49 pm Post subject: |
|
|
| If you use VBASupport 1, the order of the colors are reversed. |
|
| Back to top |
|
|
jeffkan1
General User
Joined: 14 Sep 2010
Posts: 10
Location: Kansas, USA
|
| Posted: Mon Dec 20, 2010 8:28 pm Post subject: |
|
|
Wow, you are right, VBASupport 1 is in my code. But when I commented them all out of all the modules, the color still is the same incorrect color. Other ideas? Thanks very much!
_________________
Jeff |
|
| Back to top |
|
|
hanya
Super User
Joined: 04 May 2005
Posts: 543
Location: Japan
|
| Posted: Mon Dec 20, 2010 11:18 pm Post subject: |
|
|
| Code: | CompatibilityMode(False)
'... = RGB(255, 0, 0)
CompatibilityMode(True) |
|
|
| Back to top |
|
|
jeffkan1
General User
Joined: 14 Sep 2010
Posts: 10
Location: Kansas, USA
|
| Posted: Tue Dec 21, 2010 7:53 am Post subject: [SOLVED] Cell color wrong |
|
|
THAT did it.
What are the details behind a "CompatibilityMode" command needing to be shut off, so that the RGB command works properly? Is it because the original spreadsheet was Excel? When I open the spreadsheet, I always see a message stating:
| Quote: | | Any modification that you make to the VBA macro code runs correctly but cannot be saved by IBM Lotus Symphony. Only the original VBA macro code can be saved in the Microsoft Office file. |
I see this even though I'm always editing the Basic code.
Thanks for the fix!! 
_________________
Jeff |
|
| Back to top |
|
|
|
