Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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?




  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 510
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to start the Macro when I open Excel ALICE Excel Programming 2 March 27th 06 10:09 PM
When i open excel on the start dialogue, it does not open. lemon8 Setting up and Configuration of Excel 1 December 14th 05 05:37 AM
personal.xls won't open when I start Excel Tired of Bugs Excel Discussion (Misc queries) 4 October 9th 05 10:57 PM
start Macro when file is open Martin French Excel Programming 0 February 18th 05 10:17 PM
Start macro on open Stu[_6_] Excel Programming 8 September 28th 03 04:32 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"