Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a Macro that does several things including getting the Cell
Background Fill, store it, do some work, then restore the Cell Background Fill. However, when doing this, the Cell Gridlines are gone. I understand I can set the Background Fill to "No Color" to restore this, but that would defeat the purpose of restoring the color as mentioned earlier. Code snip below: ' Change Cell Background Color ' Dim vCellBackgroundFill As Variant 'store color Dim vCellBackgroundNoFill As Variant 'store background grid vCellBackgroundFill = Selection.Interior.Color ' Do other work here With Selection.Interior .Color = vCellBackgroundFill 'restore background fill to original color .Pattern = xlSolid .PatternColorIndex = xlAutomatic .TintAndShade = 0 .PatternTintAndShade = 0 End With Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Gridlines are there, then Custom View, gridlines disappear in xl 2 | Excel Discussion (Misc queries) | |||
not all the gridlines print; despite selecting/"gridlines" | Excel Discussion (Misc queries) | |||
Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
Where are my gridlines? | Excel Worksheet Functions |