Hello,

Is there a way to reference macros in other files without
specifying what file that they are in? Somewhat like a
reference macro which you can use in any file on your PC.
Does anyone know the code for this? Thank You

Hi John

If you want to use the macro in all your workbooks you can copy the macro in
your personal.xls.
This is a (normal) 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.

You can also save the file with the macro as a add-in

--
Regards Ron de Bruin
http://www.rondebruin.nl


"John" wrote in message ...
Hello,

Is there a way to reference macros in other files without
specifying what file that they are in? Somewhat like a
reference macro which you can use in any file on your PC.
Does anyone know the code for this? Thank You

"Ron de Bruin" wrote in message
...
Hi John

If you want to use the macro in all your workbooks you can copy the macro
in
your personal.xls.
This is a (normal) 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.


But you still have to reference the file to use it.

Add-ins are the way to go.

Hi Bob

But you still have to reference the file to use it.

But you know the name<g

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bob Phillips" wrote in message ...


"Ron de Bruin" wrote in message
...
Hi John

If you want to use the macro in all your workbooks you can copy the macro
in
your personal.xls.
This is a (normal) 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.


But you still have to reference the file to use it.

Add-ins are the way to go.

-----Original Message-----
Hi Bob

But you still have to reference the file to use it.

But you know the name<g

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bob Phillips" wrote
in message ...


"Ron de Bruin" wrote in
message
...
Hi John

If you want to use the macro in all your workbooks
you can copy the macro
in
your personal.xls.
This is a (normal) 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.


But you still have to reference the file to use it.

Add-ins are the way to go.




.