Hi,
When you say autorun when Excel is opened, I'm assuming you mean when the particular workbook is opened not the Application.
Why not just use a variable that's stored in an xlveryhidden sheet in say a cell named "FirstTime"
In the Workbook open event make the first instruction
Set the variable to Yes and save the workbook.
Now it will run the first time, but any subsequent attempt to open it will immediately close it. If you don't want this nuclear option then perhaps replace the Workbook.Close with an "End" instruction.
HTH
Bookmarks