Solved: default macro

[chungtinhlak]

is there a way to set a default macro for all workbook open?

thanks

[Simon Lloyd]

If you mean run a macro when each workbook is opened then yes, but you would need to put the code in the ThisWorkbook module of PERSONAL.xls

[Bob Phillips]

Explain what you mean by default macro?

[Benzadeus]

Maybe a plugin is what you want?

[chungtinhlak]

thanks everyone, what I mean is, I have a set of macro and a userform on a workbook that I need to use all the time. If I open a different workbook, is there a way to have the new open workbook inherit these macros and userform.
thanks

[Bob Phillips]

Yes, put them in an addin.

[chungtinhlak]

is there a tutorial somewhere for this ? Never heard of it before. :0

[Bob Phillips]

Here is one http://www.fontstuff.com/VBA/vbatut03.htm

[chungtinhlak]

thanks xld

[omnibuster]

May be this helps.