VBA - Normal project file

  • Thread starter Thread starter Patrece
  • Start date Start date
P

Patrece

you know how in the visual basic editor you can store
modules in the normal project file if you want the macros
to be available at the start up of excel, well if that
normal project file isn't listed in VBA project window,
how do you get it back there? or what file do you use so
that a macro will be available at excel startup? thanks in
advance

-patrece
 
Hi Patrece

If you want to use the macro in all your workbooks you can copy the macro in your personal.xls.
This is a (normally) hidden workbook that is loaded automatically by Excel.
When you record a macro, you have the option of recording it to your Personal Macro Workbook.
The file, Personal.xls, is stored in your \XLStart directory.

The easiest is to record a dummy macro and choose Personal Macro Workbook.
Excel create the file for you this way.
Then copy your macro in this file and delete the dummy macro.
 
Back
Top