Implementing a macro on all workbooks

F

Faruk

Dear all,

First of, I wish you a nice day. I created a macro and my
initial intention is to implement only in one workbook I
have. However, right now, I am in the need of implementing
this macro for multiple workbooks. Do you know, how I can
make a macro be a fixed part of my toolbar menu so that I
can implement the macro on any workbook I do open in excel?

Thanks for your kind assistance in advance.

Regards,

Faruk
 
R

Ron de Bruin

Hi Faruk

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.
 
Top