Using VBA to change the color of Row and Column Headings

  • Thread starter Thread starter Jack Gillis
  • Start date Start date
J

Jack Gillis

Is it possible to change the color of Excel 2003 column and/or row
headings using VBA. I would like to have them appear, under certain
conditions, as something other than the dull gray. I know how to
inhibit their display but can't figure out how to change the color.
Maybe it is not possible.

Thank you.
 
Jack Gillis said:
Is it possible to change the color of Excel 2003 column and/or row
headings using VBA. I would like to have them appear, under certain
conditions, as something other than the dull gray. I know how to
inhibit their display but can't figure out how to change the color.
Maybe it is not possible.
Click to expand...

It's not possible.
 
As Harlan says no, But you could build your own in row 1 and column A, and
suppress the real ones. You can do whatever you wish with them then.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thank you Bob. Good suggestion. However, will the new ones exhibit the
same properties as the original ones such as ability to resize the rows
and columns and select entire rows and columns, etc.?

Thanks again.
 
Not that I am aware of. There may be keyboard shortcuts, but I don't know
them, but you can still do it. albeit more long-windedly.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Bob Phillips said:
Not that I am aware of. There may be keyboard shortcuts, but I don't know
them, but you can still do it. albeit more long-windedly.
Click to expand...
....

One could use the SelectionChange event handler to make clicking in the
pseudo worksheet frame in row 1 and col A select entire rows or columns.
 
Harlan Grove said:
...

One could use the SelectionChange event handler to make clicking in the
pseudo worksheet frame in row 1 and col A select entire rows or columns.
Click to expand...

Good idea.

Double-click could auto-resize :-)
 
Back
Top