How to call user define function when excel sheet being opened

Question

I'm trying to call a function when a workbook is being opened. I used workbook_open() event. But I notice that before calling function which is inside workbook_open(), all the functions that already exists in the workbook are being called.

How can I call my function to execute before calling any of functions in the workbook?

Thank you

Answer 1

I do not believe that there is a event for this in VBA.

You could add a check to all your other functions, cancelling them if Workbook_Open has not occured yet.