Stuart McLachlan
stuart at lexacorp.com.pg
Wed Oct 30 15:48:32 CDT 2013
Either put your code in the Workbook_Open event or create a macro called Auto_Open On 30 Oct 2013 at 9:41, Arthur Fuller wrote: > I don't use Excel much any more, but a friend has asked me how to do > the equivalent of an AutoExec in VBA for Excel. All he wants to do is > set a few properties when he opens a particular spreadsheet. Turns out > that only a few properties are persistent; hence the need to set them > on opening the workbook. I have no idea how to autoexec from Access. > Do you? Is it as simple as declaring the procedure "AutoExec"? > > -- > Arthur > _______________________________________________ > dba-VB mailing list > dba-VB at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-vb > http://www.databaseadvisors.com > >