MrExcel Publishing
Your One Stop for Excel Tips & Solutions

user-defined function and volatile

Posted by Russ on January 24, 2002 5:05 PM

Is there a way to set applocation.volatile globally?
I want my user-defined functions to update automatically. Visual Basic information says that the default value for Application.volatile is true, but in fact on most installations of Excel it is not.

Any advice? Or do I have to include Application.volatile true in all of my functions?



Posted by Steve Riedmueller on January 25, 2002 7:44 AM

Not positive if this is what you want but...

Tools > Options > Calculation tab > Calculation section