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