VB in Excel

[Mark Sreeves]

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?

[Judd]

Private Sub Workbook_Open()

End Sub

Should do the trick

[Mark Sreeves]

Thanks Judd!

[Judd]

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

[Libero]

U can also use:


Sub Auto_open()

End Sub


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