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.