Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal macro workbook and personal.xls | Excel Discussion (Misc queries) | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming | |||
Custom Menus in Personal.xls | Excel Programming |