I have created a few functions in VBA in XL XP, all of which work
beautifully, but only if I click on the cell containing it, then in the
edit window at the top and press enter to run it. I have calculation
set to automatic in Tools/Options. It won't even run if I press F9!
Naturally, I would like the functions to calculate automatically--just
as my other Excel functions do.

Can anyone help shed light on what is going on here?

Much thanks,

Paul.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/