vba - Can all UDFs be set to volatile globally? -

vba - Can all UDFs be set to volatile globally? -

i have several functions like:

function testxyz(rng range) dosomething() end function

i want functions recalculated every time value in sheet changes, i've changed them individually to:

function testxyz(rng range) application.volatile dosomething() end function

is there way set application.volatile globally, or have done on function-by-function basis?

it has done on function-by-function basis, might want consider setting workbook.forcefullcalculation true instead. have effect of making every recalculation recalculate every single formula including functions. of course of study create calculations slower in same way application.volatile does. can in workbook_open event

vba excel-vba