Pete

I may be an MVP but would not consider myself an expert in Excel.

More like an intermediate user.

Thanks for the vote of confidence, however<g


Gord

On Tue, 20 Nov 2007 16:42:41 -0800 (PST), Pete_UK wrote:

Gord,

you ARE one of the experts !! <vbg

Pete

On Nov 21, 12:02 am, Gord Dibben <gorddibbATshawDOTca wrote:
A question here for the experts.

I have an add-in that I reference in a workbook using VBE and ToolsReferences.

UDF's from this add-in can then be used in a CF formula.

If I reference FUNCRES.xla I still cannot use the ATP functions in CF formulas.

I assume the add-ins installed with Excel act differently from a regular
user-built add-in.

Correct?

Gord Dibben MS Excel MVP



On Tue, 20 Nov 2007 15:04:01 -0800, "Peo Sjoblom" wrote:
Since ATP is an add-in it exists physically on another sheet and you cannot
refer to other sheets when doing CF unless you use a defined name. You can
bypass ATP by putting ISODD in another cell hidden from view, or even better
in another sheet, for instance if the cell you want to CF is in Sheet1

=ISODD(Sheet1!A1)

if you put that in another sheet and call that cell for ODD
(insertnamedefine)

then you can select A1 in Sheet1 and use

=ODD=TRUE

and the CF will work

now you can hide this particular sheet with the isodd formula and nobody
will have a clue- Hide quoted text -

- Show quoted text -