Hi, I use 'Private Sub Worksheet_Calculate()' to fire certain code. Ive
done this in several workbooks, and had no problems, until now. Ive
started a new workbook, pasted some code into 'Private Sub
Worksheet_Calculate()', and the sheet is not calculating. The code I
use is from another workbook, and it works perfect in that book. I tend
to use prev code and modify it. The only way around this is to rename
the original workbook and modify the code. No big deal, but why is this
happening. Any ideas what could have changed. I looked in the options,
that apears the same. The worksheet not locked, and ive tried format
the cells in every option to no avail. Any ideas.
Regards Robert