Macro to run automatically

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

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

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....

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]