-
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?
-
Use this...
Code:
Private Sub Workbook_Open()
End Sub
Should do the trick
-
-
No problemo.
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 ;-))