I'm glad that you added the additional comments - That is exactly what I was
looking for - Thanks!!

"Gord Dibben" wrote:

Brad

In addition to Jim's information, I notice the words macro(function).

If written as a function like this

Function GetFormula(Cell)
GetFormula = Cell.Formula
End Function

it will not show up in ToolsMacroMacros

Look for it in FunctionsUser Defined


Gord Dibben Excel MVP

On Mon, 5 Dec 2005 14:14:01 -0800, "Brad"
wrote:

I've created a macro (function) that works, but doesn't show up when I select
the tool-macro-visual basic editor.

I have to play around in the macro toolbar to get the macro to show up. But
how do I change the attributes to be able to see it all the time?