Is there a way to locate an ActiveX control (specifically, a button) in a
spreadsheet, i.e., to find out what column it is in? I can figure it out if
the control has a linked cell that I can put in the same column, but that
doesn't work for a button. Although the 'location' of the left edge of the
button is a property of the button, it doesn't seem to correlate to pixels
(that could be compared against the sum of the widths of the columns to the
left of the control, for example) or anything else, as far as I can tell.

I am trying to create a series of buttons, each of which will carry out the
same action on the column in which it resides. I am using Excel 2003.

Thanks for whatever help anybody can provide!
Hugh John