Start macro on open
 

How do i get a macro to run when an excel file is opened without having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Start macro on open
 

Add the macro to your workbook_open event.
It will look like this:
Private Sub Workbook_Open()
macroname
End Sub

"Stu" wrote in message
...
How do i get a macro to run when an excel file is opened without having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Start macro on open
 

Make sure the macro starts with

(this Auto_Open macro can be placed in any VBA module in
your project)

Sub Auto_Open()

' call your macro here or place your code here

End Sub
-----Original Message-----
How do i get a macro to run when an excel file is opened
without having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.

Start macro on open
 

What if i want it to open on just one sheet and start running and not
the whole workbook?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Start macro on open
 

Stu,

Either name the macro Auto_Open and put it in a normal code module (old way)
or put it in Worksheet_Open event code in ThisWorkbook code module (new
way).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stu" wrote in message
...
How do i get a macro to run when an excel file is opened without having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Start macro on open
 

A good time to learn to use the archives and/or help. Look for auto_open or
workbook_open

"Stu" wrote in message
...
How do i get a macro to run when an excel file is opened without having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Start macro on open
 

Use the Worksheet_Activate event.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stu" wrote in message
...
What if i want it to open on just one sheet and start running and not
the whole workbook?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Start macro on open
 

Even if the auto_open is the old way I think it may have the edge.

If you have run someone else's bad code on your machine then they may
have left your application as application.enableevents = false, if
this is the case then when you try to run the workbooks_open event it
won't fire.

The EnableEvents property doesn't seem to affect an Auto_open routine.

J

"Bob Phillips" wrote in message ...
Stu,

Either name the macro Auto_Open and put it in a normal code module (old way)
or put it in Worksheet_Open event code in ThisWorkbook code module (new
way).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stu" wrote in message
...
How do i get a macro to run when an excel file is opened without having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Start macro on open
 

That's not an edge for auto_open, it's just accommodating the possibility of
poor coding.

Bob

"jason" wrote in message
om...
Even if the auto_open is the old way I think it may have the edge.

If you have run someone else's bad code on your machine then they may
have left your application as application.enableevents = false, if
this is the case then when you try to run the workbooks_open event it
won't fire.

The EnableEvents property doesn't seem to affect an Auto_open routine.

J

"Bob Phillips" wrote in message
...
Stu,

Either name the macro Auto_Open and put it in a normal code module (old
way)
or put it in Worksheet_Open event code in ThisWorkbook code module (new
way).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Stu" wrote in message
...
How do i get a macro to run when an excel file is opened without
having
to click run macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/