[dba-VB] AutoExec in Excel

Thanks. Stuart!

I am threatening to come visit you someday and to retrace Darwin's steps. I
am seriously into lizards, and especially of the PNG flavours of same.
Don't be surprised if one day I knock upon your door :)


On Wed, Oct 30, 2013 at 4:48 PM, Stuart McLachlan <stuart at lexacorp.com.pg>wrote:

> 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
> >
> >
>
>
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>


-- 
Arthur