Auto Execution
 

Hi
Needed help urgently

My macro runs only in my local workbook where its exist. I want to
change, whenever the excel application opens in the Macros list, i need
to add my macro(globally). So if i want i can select the macro and
execute it

Can any one help me.

Thanks in advance.
Marnia

Auto Execution
 

Hello Marnia
Place your macro into the Personal Macros Workbook (Perso.xls)
To achieve this, the easiest way (option #1) is to start recording a new
macro and select this option in the Record dialog box
Option #2 Just save the workbbok containing your macros into the excel
startup directory "xlstartup"
Next time you open the Excel Application, your workbook will be loaded and
your macros will be available.
You might want to hide the workbook and save it if you did not choose option
#1

HTH
Cordially
Pascal
"Marnia" a écrit dans le message de news:
...
Hi
Needed help urgently

My macro runs only in my local workbook where its exist. I want to
change, whenever the excel application opens in the Macros list, i need
to add my macro(globally). So if i want i can select the macro and
execute it

Can any one help me.

Thanks in advance.
Marnia