have button become active
 

I am trying to have a button that is linked to a macro show up in
column Y whenever someone clicks in a row.

so if i click anywhere in row 1 this button becomes visible in Row 1
column Y.
then if i click in row 2 the button in row 1 is gone and a button
shows up in row 2 column Y.
and so on.

basically i have a submit button for each row.. and once someone
clicks that button certain cells from that row are copied to another
sheet called "Log". i will keep apending the "Log" sheet and include a
time stamp so i can track the changes.

if anyone knows of a better way for me to do this please advise.

Thanks so much in advance.

have button become active
 

ONE button using something like this

sub copycurrentrowrangetolog()
ac=activecell.row
lr=sheets("log").cells(rows.count,"a").end(xlup).r ow+1
range(cells(ac,2),cells(ac.row,12)).copy sheets("log").cells(lr,"a")
end sub

--
Don Guillett
SalesAid Software

"mithu" wrote in message
ps.com...
I am trying to have a button that is linked to a macro show up in
column Y whenever someone clicks in a row.

so if i click anywhere in row 1 this button becomes visible in Row 1
column Y.
then if i click in row 2 the button in row 1 is gone and a button
shows up in row 2 column Y.
and so on.

basically i have a submit button for each row.. and once someone
clicks that button certain cells from that row are copied to another
sheet called "Log". i will keep apending the "Log" sheet and include a
time stamp so i can track the changes.

if anyone knows of a better way for me to do this please advise.

Thanks so much in advance.