Hello,
I have my procedure in Workbook_Open(), which I want to run only if th
workbook was opened 'remotely' (via VBA or Task Scheduler). Is thi
possible?

Thanks,
Jare

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

This is an untested suggestion, but look at the help on

Application.UserControl

it describes the situation for the application, but I think in the instances
you describe, it should be reliable. If you are writing the code that would
open it remotely, then you might create some condition it could check and
perhaps use a combination of that and the UserControl property.

--
Regards,
Tom Ogilvy


"Jarek " wrote in message
...
Hello,
I have my procedure in Workbook_Open(), which I want to run only if the
workbook was opened 'remotely' (via VBA or Task Scheduler). Is this
possible?

Thanks,
Jarek


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