Custom Function on Personal.xls
 

Can I create a function in the Personal.xls module so the function can be
called in another documents?

I asked this question because the ISFORMULACELL (identify if a cell contains
a formula) function that I created in the Personal.xls doesn't work on other
documents. It only works on the specific worksheet that contains that code.
I suspect that I didn't do it right. I'd appreciate if you can give me some
ideas. Thanks!

Custom Function on Personal.xls
 

=personal.xls!isformulacell(a1)

But if you're going to use this in conditional formatting, then you're going to
have trouble.

One "cheat" is to put that formula in another cell, then use that cell as your
Conditional formatting test.

(and maybe hide that cell's row/column)

AGnes wrote:

Can I create a function in the Personal.xls module so the function can be
called in another documents?

I asked this question because the ISFORMULACELL (identify if a cell contains
a formula) function that I created in the Personal.xls doesn't work on other
documents. It only works on the specific worksheet that contains that code.
I suspect that I didn't do it right. I'd appreciate if you can give me some
ideas. Thanks!

--

Dave Peterson