Hi,

I noticed that when we use the following function

OFFSET(),
NOW(),
TODAY() and so on

the formula is running and calculating every time workbook is opened . This will cause save box pop up when user click on closing button. How to apply workbook change event to turn off the save box?

I guess like this but not sure how to apply? any help would be much appreciated
Private Sub Workbook_BeforeClose(Cancel As Boolean)

End Sub