Bob, assuming i would have to replace "mybutton" with the name of the button
is there a way of the just using the button i have just pressed.

thankyou

"Bob Phillips" wrote:

Assuming it is a forms button, and it is called myButton, then use

ActiveSheet.Buttons("myButton").TopLeftCell.Entire Row.Insert


--
HTH

Bob

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

"Patrick Bateman" wrote in
message ...
is that absolutely not or absolutely? if it i possible, any idea how?


"Mike Fogleman" wrote:

Absolutely. The button is not part of the cell but floating on a layer
above
the cell.

Mike F
"Patrick Bateman" wrote in
message ...
I am running a macro from a button that inserts a new row and copies the
formulas from the row above into it, but when doing this i need to
specify
an
active cell at the point at which the new row is inseted. is it
possible
that
i can insert code that selects the cell the button is on top of?

Thankyou