VBA to run on load

do you mean when you open your workbook?

you need the macro in the workbook open module

check out this site to find out where this is..

http://www.contextures.com/xlvba01.html#Workbook


Private Sub Workbook_Open()
'your code here
End Sub