I created a user defined function in Excel 97. The function works and
I can access it in excel. I made the mistake of closing the window in
visual basic. Now I can't find the function for editing. The macros I
can find, not the user defined functions. Is there a magic word I
should know?

Functions do not show up in the macro list.

In ToolsMacroMacros, just type in the name of your UDF and "Edit"

Or Alt + F11 to open VBE then d-click on the module that holds the Function.


Gord Dibben MS Excel MVP

On Sun, 30 Nov 2008 15:47:58 -0800 (PST), Fan924 wrote:

I created a user defined function in Excel 97. The function works and
I can access it in excel. I made the mistake of closing the window in
visual basic. Now I can't find the function for editing. The macros I
can find, not the user defined functions. Is there a magic word I
should know?

You could try this, too:

Activate the workbook that owns the function.
F5 (or ctrl-g or edit|goto)
type the name of the function and hit enter

Fan924 wrote:

I created a user defined function in Excel 97. The function works and
I can access it in excel. I made the mistake of closing the window in
visual basic. Now I can't find the function for editing. The macros I
can find, not the user defined functions. Is there a magic word I
should know?

--

Dave Peterson

Good trick Dave.

Never knew about that.


Gord

On Sun, 30 Nov 2008 18:26:30 -0600, Dave Peterson
wrote:

You could try this, too:

Activate the workbook that owns the function.
F5 (or ctrl-g or edit|goto)
type the name of the function and hit enter

Fan924 wrote:

I created a user defined function in Excel 97. The function works and
I can access it in excel. I made the mistake of closing the window in
visual basic. Now I can't find the function for editing. The macros I
can find, not the user defined functions. Is there a magic word I
should know?

I'm not sure if I learned that in the newsgroups or if I did something wrong
that turned out ok!

Gord Dibben wrote:

Good trick Dave.

Never knew about that.

Gord

On Sun, 30 Nov 2008 18:26:30 -0600, Dave Peterson
wrote:

You could try this, too:

Activate the workbook that owns the function.
F5 (or ctrl-g or edit|goto)
type the name of the function and hit enter

Fan924 wrote:

I created a user defined function in Excel 97. The function works and
I can access it in excel. I made the mistake of closing the window in
visual basic. Now I can't find the function for editing. The macros I
can find, not the user defined functions. Is there a magic word I
should know?

--

Dave Peterson

Thanks Guys