| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Reports Wrong Border Color
In VBA, this code
ActiveCell.Borders(xlEdgeBottom).Color returns the original pallette color rather than the custom color the user set that pallette color to be. The spreadsheet displays the desired custom border color but the code returns only the original color. Saving/closing the workbook/Excel does not affect the problem. How do you get the actual displayed color of a border line? BTW, the environment is XL97. Tx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the default border color in Excel? | Setting up and Configuration of Excel | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
| HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL? | Excel Worksheet Functions | |||
| error checking reports a value in the formula is of the wrong dat. | Excel Worksheet Functions | |||
![Bob[_37_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
