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