Slothboi
01-17-2007, 02:41 PM
I have a macro that generates several tables of data. At the end of the tables, i want to add a new button that can re-run the macro.
The number of fields tracked is variable, so I have the macro select a cell two rows down and do selection.activesheets.button.add. At this point, if I don't know what the button number of the new button will be, how can I select the button to assign interior text, and assign a macro to it?
Thanks!
Slothboi
The number of fields tracked is variable, so I have the macro select a cell two rows down and do selection.activesheets.button.add. At this point, if I don't know what the button number of the new button will be, how can I select the button to assign interior text, and assign a macro to it?
Thanks!
Slothboi