How to start a Macro when I open Excel

[Daniela]

Hi,

thanks for your quick answer.
I tried, but it seems that it doesn't work...
Is it correct the way I create the .xla file (by saving the add-in from the
..xls file)?

Thanks,
cheers,
Daniela

Hi Daniela,

In Excel main menu, go to Tools Add-Ins and tick-off the newly created
add-in ..

HTH
Cheers
Carim

Hi,

I'm a beginner, so sorry for my stupid question.
I created a Macro in a file .xls.
I saved the file .xls with the format .xla (as add-in).
I put the file .xla in the directory C:\Programmi\Microsoft
Office\OFFICE11\XLSTART.
But it doesn't start when I open Microsoft Excel.
Why?

 

[Carim]

Hi Daniela,

I do not understand if you are talking about a macro which has to run
when you are opening your workbook, or if you are talking about an
add-in you want to make available for your workbooks ...

If you add your macro in the module This Workbook in VBE (alt F11)
under Private Sub Workbook_Open() you will have your macro running
each time you open your workbook

If you are after installing an add-in, please refer to previous answer

HTH
Cheers
Carim