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