Auto run code does not go into the Worksheet module.
Two methods...
1. In a general module
Sub Auto_Open()
'your code here
End Sub
2. In the ThisWorkbook module
Sub Workbook_Open()
'your code here
End Sub
Gord Dibben Excel MVP
On Tue, 25 May 2004 08:27:48 -0500, wyndman
wrote:
I'm trying to have Excel run a macro I have written when a spreadsheet
is opend. I have a windows script that will open Excel for me, and the
spreadsheet I need, but so far I've had little luck getting the macro
to run. I've coded it into the actual sheet to run when it starts, but
it can never find the macro.
---
Message posted from http://www.ExcelForum.com/