CODEWITHSUNDEEP
excelexcel-2010excel-2007vba
Kozero
Kozero

Reputation: 41

Automatic border colour colour code

What's the color code (ENUM) of the automatic border colour which is 25% grey? Or at least it's RGB value.

I've been searching for half an hour and couldn't find it anywhere. Here's the image of the border colour I'm talking about:

screenshot

Upvotes: 0

Views: 887

Answers (2)

user4039065
user4039065

Reputation:

To change the colour of the gridlines, go into Excel Options, Advanced (Alt+F,T,A) and scroll down to Display options for this worksheet. You can toggle gridline display and select a non-standard gridline colour there.

Alternately, you can run this on the Application.ActiveWindow property.

    ActiveWindow.GridlineColorIndex = 15   '25% grey

See Window.GridlineColorIndex property.

Upvotes: 1

Aprillion
Aprillion

Reputation: 22324

Those cells don't have any border and you can Show or hide gridlines on a worksheet in the Excel settings.

Upvotes: 1

Related Questions