PDA

View Full Version : Solved: default macro



chungtinhlak
03-03-2009, 11:12 PM
is there a way to set a default macro for all workbook open?

thanks

Simon Lloyd
03-04-2009, 01:25 AM
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
03-04-2009, 01:28 AM
Explain what you mean by default macro?

Benzadeus
03-04-2009, 04:30 AM
Maybe a plugin is what you want?

chungtinhlak
03-04-2009, 06:58 AM
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
03-04-2009, 07:06 AM
Yes, put them in an addin.

chungtinhlak
03-04-2009, 08:15 AM
is there a tutorial somewhere for this ? Never heard of it before. :0

Bob Phillips
03-04-2009, 08:51 AM
Here is one http://www.fontstuff.com/VBA/vbatut03.htm

chungtinhlak
03-04-2009, 10:26 AM
thanks xld

omnibuster
03-05-2009, 01:18 PM
May be this helps.