hi friends,

I have a command button on my excel cell. Now I want to have it some thing
like, if I save my sheet and reopen it, I should still be able tohandle the
button click...

any idea how to go about to get this?!

Thanks,
na_ab

Why is it not doing that now?, if you save the workbook, the code
should still be activated with the button when you open the workbook
again. There must be something else missing in you question.

Hey Dave,

Good to see you replying :)

Am actually having an automation addin to excel that creates
buttons(commandbuttons) on excel cells dynamically and associated event
handlers. When I save my workbook and reopen it, the buttons still exist
however the event handlers are lost. I want to persist these event handlers.
How can I do it?

My application is such that, when I build my project and run it, excel opens
up. Thus the problem is, what ever buttons and event handlers i create, they
are working only in that instance of execution. Once I save and reopen them,
though the buttons are still there, I am not able to handle the events. How
can I achieve this?!

Regards,
na_ab


"CurlyDave" wrote:

Why is it not doing that now?, if you save the workbook, the code
should still be activated with the button when you open the workbook
again. There must be something else missing in you question.