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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only