Use the workbook_Open event

See Chip Pearson's page on Events

http://www.cpearson.com/excel/events.htm


--
Regards,
Tom Ogilvy


"Glyn Davies" wrote in message
...
Good Day,
I want to eliminate all the standard toolbars and show only my custom
one when I start excel by double-clicking on an xls file. The toolbar
control I have worked out, but how to get the macro to auto run when the
xls opens I can't get right. Do I use xlAutoOpen and if so, where is it
that I can edit it?
TIA
Glyn