Make macro available in all workbooks

V

Vanessa Cassidy

Hey there

I have created a macro to run on a particular csv file. The contents of
this file are the result of a report ran from another application. I need
the macro to be available to all workbooks, so that when the macro is to be
run on the file, it will always be available.

I have tried selecting - Macros in "All Open Workbooks", but this does not
seem to retain the macro when a different file has been opened

Can any 1 help?

Cass
 
F

Frank Kabel

Hi
normally saving your file in the personal.xls should be sufficient. Aother
option would be to create an addin for this macro and install this addin
 
Top