Marc,

Did you put the Worksheet_Activate in the proper Sheet code?
If so, was the Worksheet_Activate event fired? /to check, put there something like msgbox("hello")/.
If it was fired, then was the custom function fired?

If so, then debug to see what is wrong.


>I tried to put a ActiveSheet.Calculate in the Worksheet_Activate event... but nothing is calculated. Application.Volatile does not work too.