How to call user definition function when opening excel sheet

Question

I am trying to call a function when opening a book. I used the workbook_open () event. But I notice that before calling the function that is inside workbook_open (), all functions that already exist in the book are called.

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

thank

Answer 1

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

You can add validation to all other functions by canceling them if Workbook_Open has not yet occurred.

Answer 2

, , , workbook_beforeclose. , , workbook_open, .