Right-click on the sheet tab and "View Code"

Copy/paste this code to the sheet module.

Private Sub Worksheet_Activate()
macroname
End Sub


Gord Dibben MS Excel MVP

On Fri, 24 Jul 2009 07:27:01 -0700, Derek N <Derek
wrote:

I'm trying to work out how to get a macro to run every time I open a
particular sheet of a workbook without having to create a button or 'run' the
macro.