Is there a way to determine if a book has been open manually or by macro?

[bagullo]

Wondering if it is possible to determine that a workbook has been open manually

sometimes I do "batch-refresh" and I would like to differentiate the two for traceability of changes

what I am thinking is in "beforeSave" --> if manualOpen then ... else ...

thanks!

[:) Sixthsense :)]

Why don't you pass some sort of identification in your code while opening it via code?

Like storing a (Manual/Code) value in a hidden cell or in a named range?

So based on the value change you can identify which is opened via code

[bagullo]

Once it is open, I guess I can do as you say.
for workbook open, though, i guess there's no way to detect it right?