Place the code into Thisworkbook module as Workbook_Open code

Private Sub Workbook_Open()
write some code or call your macro here
End Sub


Gord

On Thu, 17 Jan 2013 20:06:10 +0000, jaccobby
wrote:


How can I run a macro automatically when a worksheet is opened