Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet

[wyndman]

I'm trying to have Excel run a macro I have written when a spreadshee
is opend. I have a windows script that will open Excel for me, and th
spreadsheet I need, but so far I've had little luck getting the macr
to run. I've coded it into the actual sheet to run when it starts, bu
it can never find the macro. :confused

 

[Tushar Mehta]

Put the code in the Workbook_Open routine of the Workbook module.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Gord Dibben]

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