Custom Function on Personal.xls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create employee attendance db using personal.xls? 3
Where to put PERSONAL.XLS 2
functions in 'personal.xls' 4
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
personal.xls 2
How to add reference for Personal.xls? 5
Call Macro from PERSONAL.XLS 4
Where to place UDF modules for general use 8

Back
Top