Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
have a button show up
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 with and include a time stamp so i can see the changes. if anyone knows of a better way for me to do this please advise. Thanks so much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
have a button show up
See ans in later post. Pls do NOT do that
-- Don Guillett SalesAid Software "mithu" wrote in message oups.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 with and include a time stamp so i can see the changes. if anyone knows of a better way for me to do this please advise. Thanks so much in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter - Show All button | Excel Discussion (Misc queries) | |||
show all button | Excel Discussion (Misc queries) | |||
Macro to show a button? | Excel Discussion (Misc queries) | |||
Show Rows Button | Excel Discussion (Misc queries) | |||
Please help: How to make a button to show the sum? | Excel Programming |