Automatically running a macro

[Cooky]

When I run a particular Excel file, I want it to automatically run a macro on start-up. How can I do this?

Thanks,

Cooky

 

[dsi]

In ThisWorkbook under MS Excel Objects, put the code under the Workbook_Open event. If macros are enabled on startup, it will run. For older versions of Excel, you would put a macro titled Autpen in a module. Either will work. DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.