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