Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Assigned to a Button
I have 20 columns and 50 rows.
I have a macro operated from a button that selects data from one column and puts it into a cell. The button was created from the form toolbar I now want to copy the macro to the bottom of each column to select data from that column. There will be 20 buttons altogether. When I try to assign the macro to the button the first two work ok but as more buttons and macros are added the buttons in the macro box disappear and the macro cannot be assigned to the button. A message appears stating macro cannot be found although it had worked previously. Any ideas? Many thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Assigned to a Button
I've never seen macros disappear from that dialog.
As a workaround (until you find the real problem), can you copy one of the buttons that has already been assigned to the macro and just paste it where you want. The macro assignment will come with the pasting--and you can change the caption later. zephyr wrote: I have 20 columns and 50 rows. I have a macro operated from a button that selects data from one column and puts it into a cell. The button was created from the form toolbar I now want to copy the macro to the bottom of each column to select data from that column. There will be 20 buttons altogether. When I try to assign the macro to the button the first two work ok but as more buttons and macros are added the buttons in the macro box disappear and the macro cannot be assigned to the button. A message appears stating macro cannot be found although it had worked previously. Any ideas? Many thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro button on toolbar | Excel Discussion (Misc queries) | |||
How do I delete a macro in Excel 2003? Button is greyed out. | Excel Discussion (Misc queries) | |||
Button assign macro breaks with file name change and appears elsew | Excel Discussion (Misc queries) | |||
Assigning macro to button | Excel Discussion (Misc queries) | |||
Copying a workbook with custom toolbar assigned to a macro | Excel Discussion (Misc queries) |