run a macro automatically upon opening an XLS file???

Is there any way to run a given macro automatically upon opening an Excel
file, rather than opening the file and then Tools/macro/macros.../Run ?

Hi Ken,

Yes: Call that macro auto_open().

It will be auto-executed when the.xls is opened unless the user presses
the shift key during open.

HTH,
Bernd

Thankyou Thankyou Thankyou!!!!


ken

<bplumhoff@gmail.com> wrote in message
news:1133653829.175564.139800@g43g2000cwa.googlegroups.com...
> Hi Ken,
>
> Yes: Call that macro auto_open().
>
> It will be auto-executed when the.xls is opened unless the user presses
> the shift key during open.
>
> HTH,
> Bernd
>