Macro to run automatically

[Ed Namzug]

How can a Macro run automatically as soon as the file is opened or 'clicked' on?

 

[Joe4]

Ed,

Check out the following thread:
http://www.mrexcel.com/board/viewtopic.php?topic=35057&forum=2

In there, I helped someone run a macro to open the Save As dialog box upon opening a file. Follow the same steps, entering in your macro.

HTH

 

[Asala42]

Well you can toss you're code into a Workbook_Open Event..


Private Sub workbook_open()
(yourcode here)
End Sub

To apply, open the VB editor, select "This Workbook" in you're Project Explorer and toss in your code with the sub name above.

HtH

 

[kevin.philips]

If it is a macro that you want to run on open have you tried declaring the:

Sub Autpen()
Your Macro Here
End Sub

This will run whenever the worksbook/sheet opens, however the user will be prompted if they want any macros to run.... if this is not the case give me a yell and I'll try and help where I can....

 

[Ed Namzug]

Thanks Kevin, Am very grateful..!!
It worked..!!
Ed
On 2003-01-08 15:05, kevin.philips wrote:
If it is a macro that you want to run on open have you tried declaring the:

Sub Autpen()
Your Macro Here
End Sub

This will run whenever the worksbook/sheet opens, however the user will be prompted if they want any macros to run.... if this is not the case give me a yell and I'll try and help where I can....

[/quote]