CODEWITHSUNDEEP
excelvbaexcel-2007transparencycell
AJP
AJP

Reputation: 28483

How to use VBA to make a cell in Excel 2007 transparent

I currently have:

Range("Z1").Interior.Color = RGB(255, 255, 255)

But this wipes out the borders of the cells. Instead I'd just like to set the transparency of the cells in range to 1.0. The docs seem to suggest it doesn't exist (?).

Thanks!

Upvotes: 16

Views: 74122

Answers (3)

Tom
Tom

Reputation: 1

Perhaps a simple approach would be (Symbol).(line or background)Color = -1 'Transparent.

Upvotes: 0

safw
safw

Reputation: 11

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Cells.Count > 1 Then Exit Sub
    Application.ScreenUpdating = False
    ' Clear the color of all the cells
    Cells.Interior.ColorIndex = 0
    With Target
        ' Highlight the entire row and column that contain the active cell
        .EntireRow.Interior.ColorIndex = 8
        .EntireColumn.Interior.ColorIndex = 8
    End With
    Application.ScreenUpdating = True
End Sub

Upvotes: 0

Tim Williams
Tim Williams

Reputation: 166341

Range("Z1").Interior.ColorIndex = xlNone

Upvotes: 39

Related Questions