You could rename it Auto_Open.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jenni_Sweden" <JenniSweden@discussions.microsoft.com> wrote in message
news:86F84F4E-B6DC-418E-8E38-1E5980C62EBF@microsoft.com...
> How do I get my program to start at the subroutine main? (I have Visual
Basic
> 6.3). My code is:
> Public Sub Main()
> Public lengthDate As Integer
> Worksheets("Indata").Range("f9") = "main"
> dagensDatumKnapp.Show
> skapa
> End Sub
> End Sub
>
> In main I want to create certain things e.g. display text in a cell.
However
> main is nerevr executed? Help!