Macro to create macro???

[McM]

Can it be done??
I would like to create a macro and assign it to a shape using a macro.

So once the macro is ran, the file is saved containing a shape with a macro assigned to it.

Thanks so much.

 

[Juan Pablo González]

Can you have the macro already in there ? altough writing a macro to write a macro is possible, it is problematic if you or your users have Excel XP or above. It is nearly impossible as well if you need to protect the VBProject. But if you just leave the macro pre-written, then it's very easy, just add the shape and do something like

MyShape.OnAction = "TheNameOfTheMacro"

and that is it.

 

[McM]

No, the macro can not already be in the file, because the file is downloaded and replaced each night.

 

[McM]

Or maybe someone could just point me to a previous post doing something similar to what I am asking and I will look at some of the code there.

Thanks again

 

[Juan Pablo González]

Here you go:

http://cpearson.com/excel/vbe.htm

 

[McM]

I will look at it now. Thanks