Auto Open sheet function

[wilro85]

I'm curious, is it possible to set a program to run each time a sheet is accessed? I imagine it would be similiar to:

Private Sub Workbook_Open()
End Sub

Perhaps:

Private Sub WorkSheet("name")_select()
End Sub

etc...

Is this a do able task?

[Rowan]

Right click the sheet tab in question and select View Code. Then:

Private Sub Worksheet_Activate()
'your code here
End Sub

Hope this helps
Rowan

"wilro85" wrote:

>
> I'm curious, is it possible to set a program to run each time a sheet is
> accessed? I imagine it would be similiar to:
>
> Private Sub Workbook_Open()
> End Sub
>
> Perhaps:
>
> Private Sub WorkSheet("name")_select()
> End Sub
>
> etc...
>
> Is this a do able task?
>
>
> --
> wilro85
> ------------------------------------------------------------------------
> wilro85's Profile: http://www.excelforum.com/member.php...o&userid=26935
> View this thread: http://www.excelforum.com/showthread...hreadid=451397
>
>