how do i make it so my macros are always available when needed

[bsesender]

i create a monthly report that saves as a csv file. Yesterday i added two macros and saved as a macro enabled sheet. my question is this, when i run my report again, how do i utilize the same macros?

can i make the macros available from the view macro section for every spreadsheet i create so if i should need them they are there?

[HaHoBe]

Hi, bsesender,

if itīs only you who will use the macro (and always on the very same computer) the personal.xlsb could be the place as this workbook is loaded when Excel starts up. Alternative to that: put the macro enabled workbook in tge startup folder, it will be loaded each time Excel starts. If you want to share the macros or use them on different computers you should consider creatiung an AddIn (have a look at Creating An XLA Add-In For Excel for some information).

Ciao,
Holger

[JBeaucaire]

Open the VBEditor and move the macros into a module in the Personal.xls workboook project.

If this module doesn't exist, go to an empty sheet and turn on the Macro Recorder to record a junk macro, but be sure to tell Excel to place the macro into the Personal Macro Workbook. Type some junk and turn off the recorder. This just created the Personal.xls workbook for you.

2012-11-16_1035.png

Your macros may need some attention, make sure there are no references to ThisWorkbook in them or they will refer to the hidden Personal.xls workbook instead of the activeworkbook or such.