Herminio,

One way would be to use the Auto_Open event procedure to set a
flag variable. Because Auto_Open is not called executed when a
workbook is opened via VBA, it will run only when the workbook is
opened manually. E.g.,

Dim OpenByUI As Boolean

Sub Auto_Open()
OpenByUI = True
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Herminio " wrote in
message ...
Hi fellows!
I need know what method was used to open my workbook, that is,
a mouse
click or a VBA workbooks.open.
Is there any way to find out it?
Thanks!
Hermínio.


---
Message posted from http://www.ExcelForum.com/