worksheet doesn't recognize module when I rename it

**14ChowHound** · 06-14-2013, 10:43 PM

Can anyone help? When I rename my VBA module my worksheet will not recognize my UDF. Works fine when I change it back to "Module1".

**MarvinP** · 06-14-2013, 11:10 PM

Hi and welcome to the forum,

I just did what you suggest and find my UDF still works, even after renaming Module1 to MyModule.

Let's try some other answers. Did you recompile your code after changing the name? Do you have Calculations set to Auto or do you recalculate? Do you need a Application.Volatile in your UDF so it recalculates? Did you put your cursor in the cell the UDF was in and press enter?

I just don't find the problem with my example.

**14ChowHound** · 06-15-2013, 11:35 AM

Hi MarvinP,
I am just a beginner in working with UDF. I tried changing the name and recompiling, ensured auto calculations set, added application.Volatile, and I do put my cursor in the cell to restart call sequence. Still no help. Something I didn't mention was that the name change works until I close my worksheet and reopen it again (I should have put this in my original post. sorry).

**Norie** · 06-15-2013, 12:04 PM

What did you rename the module to?

**MarvinP** · 06-15-2013, 12:21 PM

Hey Norie,

This is what I think s/he meant by renaming the module: http://answers.microsoft.com/en-us/o...c-68b599b31bf5

**Norie** · 06-15-2013, 12:45 PM

Marvin

I was asking what the OP has renamed the module to.

**14ChowHound** · 06-15-2013, 11:33 PM

in VB I selected the module and changed the name in properties. I saw Norie's Question about what I named the module to and it started me thinking. I was naming the module the same as my function. I renamed the module with a variant of my UDF so I would know what it was. It seems to be working fine now. Again, I am just beginning. Thanks all for the help!