Without seeing it we are a bit in the dark, but it sounds like a simple
Control toolbox control that is only made visible when the header is
selected and the click event of that control does the rest.

Look at the worksheet code module for that sheet and see if there is code in
there.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"davegb" wrote in message
ups.com...
Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

There is a column header with text in it in Column E. If another cell
is selected, it looks like a normal column header. But if I select
that cell, a tiny control button with a down arrow in it appears to
the lower right of the cell, actually in the lower left corner of the
cell to the right of the header cell I selected. If I click on the
little arrow, a tiny menu appears, with 2 options. One is the column
header I've been seeing, the other is a different column header which
I can select. That changes the original column header to the new one.
But it also changes the 2 columns to the right of the original column,
columns F & G. Until I select the alternate column header in E, F is
blank, and G has a "normal" column header and numbers down the column.
But when I select the alternate column header in E, column G goes
blank, and F appears with a header and numbers. Of course, other cells
in the spreadsheet are dependents on these columns, based on IF
statements testing the text in the original column header. Pretty
slick! I'm sure some of you here know how to do this. Can someone
explain it to me? Not looking for step-by-step yet, just a general
idea of how it's done.

As always, thanks!