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.

Thread: Solved: default macro

Thread Tools

Display

Solved: default macro

Posting Permissions