how to share macro for different workbook...

[sokevin]

Hi,

I am VERY new to macros....

i used a macro so that it display file path in the footer. i called i
"pathinfooter".


I created this in the workbook called workbook1.xls

how can i use this macro "pathinfooter" for all workbooks withou
having to re-create the macro again?


i.e can i save the macro so that it is available all the time?


thanks :

 

[Guest]

Easiest way is to put it in the Personal Macro Workbook. If you are very new to macros, consider opening a workbook and recording the macro again. When you are in the box in which you create the macro, change the Store Macro In option to Personal Macro Workbook
This creates as workbook named Personal (if it doesn't exist already) in the startup folder, so that any macros stored in it are always available when you have Excel open

tj

 

[Dave Peterson]

You may want to look at the way John Walkenbach implemented his version:

http://j-walk.com/ss/excel/files/addpath.htm

Then you could save that addin somewhere nice and load it via Tools|Addins and
browse for your file.