Auto Run function on Startup

[Gareth Saunders]

Hi there

I have a strange problem and am not sure if it's possible. However, I'm what
I'm wanting is when I open a certain spreadsheet (eg book1.xls) I would like
a function to load up but not when any other workbook is loaded. So what I'm
trying to do is to get this function to load up on one spreadsheet only and
not any others. Is there any way of doing this?

Many thanks

Gareth Saunders
BOFH

[Otto Moehrbach]

What do you mean by "function load up"? What do want to happen?
To have something happen when you open a specific file you can write a
Workbook_Open macro and include code within that macro to do what you want.
Post back with more info. HTH Otto
"Gareth Saunders" <[email protected]> wrote in
message news:[email protected]...
> Hi there
>
> I have a strange problem and am not sure if it's possible. However, I'm
> what
> I'm wanting is when I open a certain spreadsheet (eg book1.xls) I would
> like
> a function to load up but not when any other workbook is loaded. So what
> I'm
> trying to do is to get this function to load up on one spreadsheet only
> and
> not any others. Is there any way of doing this?
>
> Many thanks
>
> Gareth Saunders
> BOFH
>