macro entry point

hello all

I am designing a solidworks MACRO to extract dimensions and input to excel. Previously, i have just had

Sub Main()
...
End Sub

Now, i have added an extra function, which main() calls.

Sub Main()
...
function
...
End Sub
--------------------------------
Sub function()
...
End Sub

My problem is that when run from SolidWorks (not the editor debugger), the macro enters the function, rather than main!?!?!?!

What am i doing wrong?

Thanks

Seedie54