Implementing a macro on all workbooks

[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

 

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

 

[Dave Peterson]

It may seem like overkill with just one macro, but John Walkenbach's MenuMaker
program is a pretty neat way to update the menubar.

http://j-walk.com/ss/excel/tips/tip53.htm

But it'll make life easier if you start this way and grow.