AUTO START

[JIMBO]

How do i automatically start a macro evrytime i load a
worksheet.

Thanks

Ed

 

[Chip Pearson]

Ed,

In the ThisWorkbook code module, use

Private Sub Workbook_Open()
' your code here
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Nicke]

Hi,

Create a macro called AUTO_OPEN in a module or put the coden in th
Workbook_Open sub, you'll find it in ThisWorkbook.

/Nick