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

Check your earlier post.

hjc wrote:

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

--

Dave Peterson

Thanks, Dave -- for some reason, my first post 'disappeared' after I
submitted it, and I could find no trace of it. In fact, I didn't even think
I posted it (at least, not intentionally, nor even accidentally, as far as I
was aware), but I suddenly got a message saying that it had been successfully
submitted. So, when I couldn't even find it after that, I posted it a second
time....

H.J.

"Dave Peterson" wrote:

Check your earlier post.

hjc wrote:

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

--

Dave Peterson