View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Editing user defined functions

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?