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

Thanks

Ed

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


"JIMBO" wrote in message
...
How do i automatically start a macro evrytime i load a
worksheet.

Thanks

Ed

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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com