I have the following UDF, using it in conjunction with conditional
formatting, to format cells that a formula has been over typed

Function IsFormula(cell)
Application.Volatile
IsFormula = cell.HasFormula
End Function
I created a module for it and it is showing up in the editor.

CF formula is =isformula(active cell)

The formatting worked the when I created it. Now that I have saved and
reopened it doesnt work.

What am I doing wrong?

Thanks a million!

Any chance you didn't enable macros when you opened the workbook?

(It worked ok for me when I did it.)



steveh wrote:

I have the following UDF, using it in conjunction with conditional
formatting, to format cells that a formula has been over typed

Function IsFormula(cell)
Application.Volatile
IsFormula = cell.HasFormula
End Function
I created a module for it and it is showing up in the editor.

CF formula is =isformula(active cell)

The formatting worked the when I created it. Now that I have saved and
reopened it doesnt work.

What am I doing wrong?

Thanks a million!

--

Dave Peterson