personl.xls (storage of VBA-Code)

W

Walter-U. Kellner

Hello everybody,

I had you reinstall EXCEL and can't find the place any more, where I define
the storage place for VBA-code and macro-code. I'd like to put everything in
personl.xls, but where can I turn that option on?

thanks for your help!
Walter
 
P

Peo Sjoblom

You have to create personal.xls first, you can just record a dummy macro and
select personal macro workbook instead of this workbook, just start and stop
the macro, then delete all the code recorded and oput in your macros there
(press alt + F11 to open the VBA editor and select the personal from the
project pane, double click module 1)


Regards,

Peo Sjoblom
 
Top