In the ThisWorkbook module

Private Sub Workbook_Open()
' any conditions you might want
PullExistingDataToHand
End Sub

See Chip Pearson's page on Events
http://www.cpearson.com/excel/events.htm


--
Regards,
Tom Ogilvy

"John" wrote in message
...
The following macro call works fine when a specific cell is updated. How
do I
call the macro when the worksheet is first opened?

Private Sub Worksheet_Activate(ByVal Target As Excel.Range)
If Target.Address = Range("hanwono").AddressLocal Then Call
PullExistingDataToHand
End Sub