Excel 2007 : Module code not being recognized

**pcap** · 01-13-2010, 01:06 AM

Hi, I am not yet an excel power user and am pulling my hair out over this issue. Here is my issue, any help would be greatly appreciated.

1. I have a macro-enabled spreadsheet in excel 2007.
2. I made a module and wrote some functions in it.
3. I used those functions throughout my workbook. Everything worked fine.
4. I closed and reopened the spreadsheet. Now when I update anything I get #NAME? errors for all of my user defined functions.

I sent the file to a friend, and the module with the code is present in the file. I also can see the functions if I go to Formulas->Insert Function. When I try and use a function through Formulas->Insert Function, it sets the name of the function to

'filename.xlsm'!Module1.MYFUNCTION()

which is different than what I used which was just

MYFUNCTION()

but still results in the same #NAME? error.

Really confused since the code is present in the file, and the workbook is macro enabled. Please help.

**Jbentley** · 01-13-2010, 02:53 AM

Any chance of posting a desensitised sample workbook with the functions?

**pcap** · 01-13-2010, 04:59 PM

Thanks for getting back to me. I can't desensitize too much sadly, but I can give you a more specific example with specific names.

In one sheet, I have cells with this value

=Impressions(L10,'Exec Summary'!G27,'Exec Summary'!G28)

In my module, named 'Module 1', the corresponding function is

Please Login or Register  to view this content.

**pcap** · 01-13-2010, 05:04 PM

On another side note, when I begin to type into the formula bar, the functions show up in the typeahead search but still when I try and use one it gives a name error.