David
Most strange.
I have tried to find a reference to check in ToolsReferences so's I could use
the ATP functions in CF.
The closest I can get in FUNCRES.XLA if it is open(ToolsAdd-insATP)
But I still get the "Cannot use" message"
Don't have this problem with my own Add-ins.
Gord
On Tue, 22 Aug 2006 15:30:36 -0400, "David McRitchie"
wrote:
Hi Conan,
I forgot that a user defined function had to be in the same
workbook, so that would apply to addins as well.
Could not find a reference to set in the VBE for the
Analysis Toolpak, but using MOD would be better
anyway.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Conan Kelly" wrote
I was getting the message that I can't use external references,
but I wasn't using external references. I was trying to reference
the cell I was applying the conditional formatting to though.