There is no way to determine this. Why should the code care?
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Matthew Wieder" wrote
in message ...
What property can I use in a UDF to determine wether the
calculation currently exectuing is as a result of an F9 push
vs. the result of the workbook being opened and 'auto calc on
open' is set? I know about determining wether excel is set to
auto calc vs. manual calc in general, but this case is where it
is set to manual calc with the exception of the 'auto calc on
open' setting and I need to tell the difference between the
two.
thanks.