On Wed, 4 Mar 2009 06:17:01 -0800, TimDB
wrote:


Sorry, calculation_mode wasn't the best choice of words, since
CalculationMode is a real property that refers to automatic or manual
recalculations. Changed to fictitous property "calculation_type" to avoid
confusion....

If Sh.Parent.Name = "MyBook.xls" And Sh.CodeName =
appXL.ActiveSheet.Name Then
If "calculation_type = <shiftF9" Then 'pseudo-code!
'do stuff
Else If
'do other stuff
End If
End If



I don't know of any way to tell how the calc was initiated.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com