Based on my understanding (and anyone else can chime in if I'm incorrect), the Workbook Scope SheetCalculate code may not be appropriate if there are linkages among sheets. I believe that Excel runs the code for each sheet subsequently; if multiple sheets link to an original sheet, the code will run for each dependent sheet. For example, if Sheets 2, 3 and 4 each have a formula that links to sheet 1, then if this value becomes negative, you will get 3 separate message boxes (1 per sheet).
I believe the BEST approach is to write code in a module, and have that code called whenever there is a workbook change. This is a two step process. First, enter the below code in a STANDARD MODULE. Note: as per before, the code will check column 2 for negative values, as defined by the Const col As Long = 2
line of code
Next, enter the following code in the ThisWorkbook module:
Report back if this helps.
Bookmarks