Macros personal library

[DOF2001]

I update to Excell 2003 and i need to set up my personal library of macros. can anyone give a hint, How can a create a VBA project that it will stay active all teh time i am using excell

Thanks

 

[shajueasow]

Hi,
When you record macros, store it in personal.xls instead of This Workbook. Then it will be available whenever you use Excel.

 

[DOF2001]

Thanx but how i create the PERSONAL.xls

 

[Richie(UK)]

Hi D,

Record a macro and in the 'Store macro in' box select 'Personal Macro Workbook'.

HTH