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

__________________
Visit my site: http://www.drybonesuk.com

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

thats brilliant thanks, just what i was after.

thanks again

Patrick

Visit my site: http://www.drybonesuk.com