ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to start a Macro when I open Excel (https://www.excelbanter.com/excel-programming/357751-how-start-macro-when-i-open-excel.html)

Daniela[_2_]

How to start a Macro when I open Excel
 
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

"Carim" ha scritto nel messaggio
oups.com...
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

How to start a Macro when I open Excel
 
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



All times are GMT +1. The time now is 05:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com