[SOLVED] Can I run a macro on loading?

I want to run a macro to run VBA on loading the spreadsheet to, say,
bring up a splash screen and then force a save under a new name before
the user starts working with it.

I cannot find an 'on load' command or anything which might do this.

How can this be done?

Thanks
Brian

in the vb editor, click the thisworkbook in the project explorer and then select
workbook from the general dropdown and open from the declaration dropdown.

the code here will run when the workbook is opened

--


Gary


"Ashnook" <brian@atashnookcdtfreeservedotcodotuk> wrote in message
news:[email protected]...
>I want to run a macro to run VBA on loading the spreadsheet to, say, bring up a
>splash screen and then force a save under a new name before the user starts
>working with it.
>
> I cannot find an 'on load' command or anything which might do this.
>
> How can this be done?
>
> Thanks
> Brian

or you could call your macro: Sub Auto_open()

Originally Posted by Ashnook

I want to run a macro to run VBA on loading the spreadsheet to, say,
bring up a splash screen and then force a save under a new name before
the user starts working with it.

I cannot find an 'on load' command or anything which might do this.

How can this be done?

Thanks
Brian