Reply to thread

Message: [QUOTE="Gary''s Student, post: 6434882"] Consider: Public b As Boolean Sub dural() b = False End Sub Function bb() Application.Volatile bb = b End Function Sub second() b = True Application.CalculateFullRebuild End Sub The real problem is that Excel has to know when to re-calculate =bb(). By including the Volatile statement, the function will be re-calculated whenever the worksheet is re-calculated. It is now the responsibility of the sub that modifies the public variable to also re-calculate the worksheet, thus refreshing the value of the function. [/QUOTE]