bdsii
01-10-2010, 09:55 PM
I have one macro that runs calculations and displays the results inside a spreadsheet in rows and columns.
I would like to be able to have the original macro enable or activate a button that can be clicked which would then initiate a second macro to perform additional calculations from the results of the first macro. The second macro would be run frequently and needs to have a simple button to click to start rather than trying to run it through the the macro menu of the spreadsheet.
Currently I have buttons for the user to initiate the first macro and a second buttton is not hard to create and assign the second macro but I would like for that button to be inactive or "grayed out" for the user until the first macro runs providing the data needed by the second macro.
So.....can anyone suggest code that can be run from inside one macro to create or enable a button to run a second macro ?
I have tried doing this using the record feature in the spreadsheet but I cannot get the insert shape function to work and cannot assign a macro to an existing shape which was a workaround for enabling a button.
Any ideas ?
Thanks !!
I would like to be able to have the original macro enable or activate a button that can be clicked which would then initiate a second macro to perform additional calculations from the results of the first macro. The second macro would be run frequently and needs to have a simple button to click to start rather than trying to run it through the the macro menu of the spreadsheet.
Currently I have buttons for the user to initiate the first macro and a second buttton is not hard to create and assign the second macro but I would like for that button to be inactive or "grayed out" for the user until the first macro runs providing the data needed by the second macro.
So.....can anyone suggest code that can be run from inside one macro to create or enable a button to run a second macro ?
I have tried doing this using the record feature in the spreadsheet but I cannot get the insert shape function to work and cannot assign a macro to an existing shape which was a workaround for enabling a button.
Any ideas ?
Thanks !!