G
Guest
The other gentleman was correct that you can't change the
headings, but I have an idea that might give the illusion
that they are changed. Of course you won't have any of
the functionality of the A, B, C column headings, but your
spreadsheet will look better. Go to Tools Options and the
View Tab. Then you can turn off the Column and Row
headings. This will leave you with just the worksheet,
which you can add headings in the first row and across the
columns that you need. If you were feeling really frisky,
you could create buttons using the Control toolbox and
draw them to be the same size as your columns and then
label the buttons. This will look very similar to Column
headings, and it gives you the added flexibility that you
can program in some of the functionality of the column
heads. To do that you simply record a macro, then click
on the Triangle from the Control Tool box, followed by
double clicking on your button. In the blank spot that
comes up in the VBA you will put Call MacroName. Note:
MacroName is the actual name you chose for your macro, if
you chose Fred the code would be Call Fred.
This is just a thought I hope it helps.
headings, but I have an idea that might give the illusion
that they are changed. Of course you won't have any of
the functionality of the A, B, C column headings, but your
spreadsheet will look better. Go to Tools Options and the
View Tab. Then you can turn off the Column and Row
headings. This will leave you with just the worksheet,
which you can add headings in the first row and across the
columns that you need. If you were feeling really frisky,
you could create buttons using the Control toolbox and
draw them to be the same size as your columns and then
label the buttons. This will look very similar to Column
headings, and it gives you the added flexibility that you
can program in some of the functionality of the column
heads. To do that you simply record a macro, then click
on the Triangle from the Control Tool box, followed by
double clicking on your button. In the blank spot that
comes up in the VBA you will put Call MacroName. Note:
MacroName is the actual name you chose for your macro, if
you chose Fred the code would be Call Fred.
This is just a thought I hope it helps.