Creating a Macro, that creates a new Button, which itself runs a Macro.. Possible?

Hi everyone,

I'm struggling to find any help on this.

I have a long complicated macro that processes a ton of data and gives the output in a new sheet. I then want to create new buttons (or some sort of user clickable triggers) on this new sheet that runs another macro.

I have got the actual adding of buttons in the sheet working, but I can't find a way to automatically assign macros to newly generated buttons during runtime. Is this even possible (or are there any clever tricks I could use to get around this?)

I think essentially what I'm wondering is if it is possible to have a macro can itself write:

Please Login or Register  to view this content.

to a sheet's underlying code. Or is there a way of dynamically assigning a macro to a click event of an object?

Perhaps using OnAction?

Please Login or Register  to view this content.

StephenR's answer is correct. If you'd like to have a little fun with your button, you can add a Staple's style "easy" button. The code is in my blog here:Create an Easy Button

Ah ha!

I've been using Forms button objects which can't use OnAction, but using shape buttons work just as well.

Many thanks