VB in Excel

This is my first attempt at using VB in Excel

I've written a function to be included in a spread-sheet but some variables need initalising when it first runs.

If it was a normal vb form I would call it from Form_Load so it only runs once.

Is it possible to run initialisation code when a spread-sheet is first opened?

Code:

---

Private Sub Workbook_Open()

End Sub

---

Should do the trick

Thanks Judd!

That was quick, so I figure you're in the UK someplace? And at work already, like me :)

U can also use:


Sub Auto_open()

End Sub


(I dont want any viruses from u then ;-))