Autorun

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kenan Kilictepe - 13 Apr 2006 21:59 GMT

I want to show a userform whenever a user creates a new file.
I thought to change the default template but couldnt find the right sub
name.
Is this possible? is there a default method like sub autoexec().

Thanks.

Reply to this Message

Dave Lett - 13 Apr 2006 22:18 GMT

Try AutoNew.

You can look in the help topics under "Auto Macros" for more information.

HTH,
Dave

>I want to show a userform whenever a user creates a new file.
> I thought to change the default template but couldnt find the right sub
> name.
> Is this possible? is there a default method like sub autoexec().
>
> Thanks.

Reply to this Message