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?