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
. com...
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()


Ashnook Wrote:
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


--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=520323