With your workbook open hit Alr +F11 to open the VBE

Select your workbook/project and expand it.

Do you see any modules?

Open them to see what's in them.

Also check in sheet modules just in case someone stored the UDF in one of
those.

Also see Bob's reply about F5 and type the name for a shortcut method to the
UDF

That would be done from the Excel window.


Gord


On Mon, 04 Jan 2010 13:20:23 -0700, Howard Brazee wrote:

On Mon, 04 Jan 2010 11:59:08 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

SumEvalString is a User Defined Function and will not show up in the list of
macros in ViewMacros.

ViewMacros is empty it's not finding any macros at all. Even in
"Open all workbooks", which scares me a bit - as other documents have
VB in them).

I'm trying to remember if I may have opened this document at home with
Office for Mac. If so, could macros get lost from a document?

I did a search of "all files and folders" in this folder containing
the string SumEvalString. It found the .xls document, but not the
.xlsm document. I found this odd, as I can see it in the .xlsm
cells. So I opened the .xls file (in compatibility mode) and tried
to read the macro. No dice. I am not finding it.

I'm assuming I need to find it before continuing.

You will find the UDF in a general module.

Developer TabVisual Basic to open the VBE.

Double-click on a module to open.............look for the UDF

If Developer Tab is not shown on the ribbon you must place it there.

ButtonExcel OptionsPopularShow Developer Tab in Ribbon.


Gord Dibben MS Excel MVP

On Mon, 04 Jan 2010 12:10:27 -0700, Howard Brazee wrote:

On Mon, 04 Jan 2010 11:58:46 -0700, Howard Brazee
wrote:

I have a spreadsheet that hasn't been changed since my work upgraded
my Office. I don't remember where they hid the part that shows what
version of Excel I have. But that's normal with this new Office
hardly anything I used to know how to find is hidden.

I need to change a VB macro, but the View/Macros did not show anything
and I know there is some VB in this spreadsheet. I saved this
spreadsheet from compatibility mode to a XSLM form, opened it again,
and still can't find the macros.

How do I get to the Visual Basic?

Oh, my column has the formula:

=SumEvalString(G2:INDEX(G2:CN2,MATCH(Base_Year, $G$1:$CN$1,-1)))

I don't remember how this works (What is CN2?) - but it might be a
clue about where my macros are.