Hi. An excel file is opened by people, but also by code from a VB
application.

I would like the code in Workbook_Open to run whenever the file is
opened by a human, but not to run when the file is opened by
automation.

Any ideas ?

Thank you very much
Alex.

hi, Radu !

> Hi. An excel file is opened by people, but also by code from a VB application.
> I would like the code in Workbook_Open to run whenever the file is opened by a human
> but not to run when the file is opened by automation.
> Any ideas ?

(i.e.)

Private Sub Workbook_Open()
If Not Application.UserControl Then Exit Sub
' here your normal actions ...'
End Sub

hth,
hector.

In the code that will open the file (by automation) bracket the file open
command with:
Application.EnableEvents=False
'your file open command goes here
Application.EnableEvents=True
HTH Otto
"Radu" <(E-Mail Removed)> wrote in message
news:68cd9bdd-72a6-4a4a-bf17-(E-Mail Removed)...
> Hi. An excel file is opened by people, but also by code from a VB
> application.
>
> I would like the code in Workbook_Open to run whenever the file is
> opened by a human, but not to run when the file is opened by
> automation.
>
> Any ideas ?
>
> Thank you very much
> Alex.

Wow ! Great tips, guys ! Thanks a lot - tomorrow I'll try both
solutions - first thing in the morning.

Thanks again, and have a great day !
Radu