View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default UDF error when renaming Module1

On Sat, 27 Nov 2004 04:35:13 -0800, "RonaldF"
wrote:

Hello,

I have made a UDF in Module1, but when I rename the Module1 to a name I can
easaly recognize. I have to put the full name into Excel to get it working.
Before rename: =function
After rename : =Newname.function

Is their a simple solution to my problem or is it not possible to rename
Module1.

Greetings Ronald.


This is usually due to multiple modules/functions/names with the same name.
This "same name" may be in a module in an add-in.

So you can rename module1, but you must ensure that the new name is
unambiguous.


--ron