[RESOLVED] Absolutely bizarre workbook behavior

[MartinLiss]

I deal with a workbook and the workbook I've linked to is, believe it or not, a cut down version of that workbook, and as is none of the buttons on sheet1 work. The file is large because of the formatting of sheet1 which extends all the way down to row 1048576, but that's not the problem I need help with.

The problem is the 3 Public Functions in Module2. They don't get explicitly called from anywhere but bizarrely they do get called when Sheet1 is changed or a worksheet is added or deleted. To see it happen, place breakpoints on those 3 functions and execute the simple "test" macro that you'll find in Module1. You can follow this link https://www.mediafire.com/file/ggni5.../Demo.zip/file to MediaFire and download the workbook.

Hopefully someone can tell me the cause.

[Zvoni]

The problem is the 3 Public Functions in Module2. To see it happen, place breakpoints on those 3 functions and execute the simple "test" macro that you'll find in Module1.

Set Breakpoints in the 3 functions in module2, and ran "test"
Cannot confirm!
It's not entering the functions.
Adding a sheet doesn't fire the code, but deleting it!

At a guess: When deleting, your sheet becomes the active one.
Do you have in Options something like "calculate sheet when it becomes active"?

And you're wrong about "the functions not getting called anywhere":
For instance: e.g. In Column GJ10 you have "=GetDouble(BF10)" with the other 2 functions also there in the following columns.
That is "being called"

Bottom line: Your sheet becomes active, it starts recalculating everything, incl. your custom functions

[MartinLiss]

And you're wrong about "the functions not getting called anywhere":
For instance: e.g. In Column GJ10 you have "=GetDouble(BF10)" with the other 2 functions also there in the following columns.

I looked into this problem several times and it never occurred to me to check to see if those functions were being used as UDFs. Thank you!