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

Robert,
Check the values of:
Application.EnableEvents
Application.Calculation

But if no cells have been marked as Dirty (because formulae/precedents etc
change), no Calculate event will occur.
e.g. A1 is changed from "text1" to "text2" will not fire this event.

NickHK

"RobcPettit" wrote in message
oups.com...
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

Thankyou for your reply. Ive checked the values and there both correct.
Made no difference though.
Regards Robert
NickHK wrote:
Robert,
Check the values of:
Application.EnableEvents
Application.Calculation

But if no cells have been marked as Dirty (because formulae/precedents etc
change), no Calculate event will occur.
e.g. A1 is changed from "text1" to "text2" will not fire this event.

NickHK

"RobcPettit" wrote in message
oups.com...
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