Excel:Detect row a button is located on with VBA?

[scobiej]

I have a button on a spreadsheet that inserts a row. simple, trouble is there are other buttons below it. if the 1st one is fired then the next button creates the row in the wrong place cos each button is hardcoded to the row it starts at.

How do I on the button click code detect the row the button sits on? Its as if the button just floats on top of the spreadsheet. I want to assign a button to a cell. Either that or use an image or can u get a cell click event? If so it would solve my problem.

any comments appreciated
j

[RobDog888]

Buttons are drawn on a different layer and not "in" the actual
spreadsheet layer. I guess you could use variables to keep track
of the row each button is on. Then when you click one you will
know what button is pressed and you can move each button
below to the correct positioning.

The logic of the spreadsheet is not very programmer friendly.
Couldn't you get rid of the buttons on the spreadsheet and
create a custom toolbar or menuitems to do the same thing. Then
you wouldn't have to worry about control positioning.

HTH