Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automatically running a macro

Status
Not open for further replies.

Cooky

Mechanical
Joined
Jan 14, 2003
Messages
114
Location
GB
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
 
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 Auto_Open 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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top