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 |
Can I run a macro on loading?
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 |
Can I run a macro on loading?
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 |
All times are GMT +1. The time now is 02:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com