|
Subject:
|
start on load
|
|
Posted By:
|
ozPATT
|
Post Date:
|
10/6/2005 5:26:25 AM
|
hi again,
could someone help me out with some syntax?
i want to write a sub, which starts as soon as the spreadsheet opens... but I don't know how to do that. is there like an onLoad function, cos I can't find that anywhere..
thanks
Patrick
Visit my site: http://www.drybonesuk.com
|
|
Reply By:
|
maxpotters
|
Reply Date:
|
10/6/2005 5:29:55 AM
|
Hi Patrick,
Goto the VB Editor. Here double-click on ThisWorkbook (which can be found in the Project Explorer --View>Project Explorer).
A blank field will show up at the right. From the left pulldown menu, select Workbook. You will now see that the blank field consists of the following lines:
Private Sub Workbook_Open()
End Sub
Between these lines you put your code which you want to run during startup.
Hope this helps
Max
|
|
Reply By:
|
ozPATT
|
Reply Date:
|
10/6/2005 5:46:55 AM
|
thats brilliant thanks, just what i was after.
thanks again
Patrick
Visit my site: http://www.drybonesuk.com
|
