[dba-VB] AutoExec in Excel

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
> 
> 




More information about the dba-VB mailing list