![]() |
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? |
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