How create a new Project in VBA

L

LiveUser

I somehow lost me Personal Macro collection. I am wondering how to create a
new project so I can name it and start creating modules.

Thank you.
 
F

FSt1

hi
just name a standard xl file as personal.xls and start dumping modules in
it. save it the the xl start up folder. and create a back up for it.

regards
FSt1
 
G

Gord Dibben

Tools>Macro>Record New Macro>Store Macro In>Personal Macro Workbook

Record anything and stop recording. You now have a Personal.xls


Gord Dibben MS Excel MVP
 
L

LiveUser

Gord Dibben,

Surprising to me, that would not work, !at the time!. I don't know why and
since i created my new personal project my old personal project appeared...
weird.
 
Top