Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default start Macro when file is open

"?B?amFtZXM=?=" wrote in message ...
I would like to automatically start a Macro when the file is open.
Would anyone help?

Thanks in advance.

jj


Hi

I believe the procedure you want is called Auto_Open()
It needs to go in a module like this:
Sub Auto_Open()
msgbox"Hello from Auto Open"
End Sub

Hope this helps

Martin French
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
Deleted file tries to open when I start Excel Prospector Excel Discussion (Misc queries) 3 September 17th 09 04:31 PM
How do I prevent Excel trying to open a non-existing file at start Jesperfect Excel Discussion (Misc queries) 0 May 15th 09 01:11 PM
Open File on PC Start Up (Office 2007) Great Simms Excel Discussion (Misc queries) 1 February 9th 08 04:45 PM
How do I start a new application when I open a file? jkwillis99 Excel Discussion (Misc queries) 1 January 13th 06 01:16 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 04:59 PM.

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

About Us

"It's about Microsoft Excel"