Put your code in the Workbook_Open event, in the ThisWorkbook module that you
see in the project pane in the VB Editor.

On Mon, 25 Oct 2004 21:31:29 -0500, Sha-auto
wrote:


Hi,
I need to run a Macro automatically, when I open a file - is this
possible ? If so could you let me know how, or steer me in the right
direction at least. I couldn't find it in Excel help or on this forum
as a question posted previously.
I want to open a file from a desktop shortcut and then run the Macro
automatically...
Many thanks to all you Excel wizards out there, I found some very
interesting ideas/solutions when hunting for this answer.