Add the macro to your workbook_open event.
It will look like this:
Private Sub Workbook_Open()
macroname
End Sub

"Stu" wrote in message
...
How do i get a macro to run when an excel file is opened without having
to click run macro?

Thanks



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