how clear up this problem
 

For some reason, for the last months, whenever I try to open up an excel
file, the code for one of my vb modules in my personal folder comes up
all the time.

At the top, it says microsoft vb - personal.xls module14 (code). There
is an error message: compile error: ambiguous name detected. When I
click the x at the corner right top, the code screen clears. But then I
am asked whether I want to enable or disable the macro.

Finally, the excel file which I had originally intended to open appears.
But this problem of this mysterious module code always coming occurs all
the time, even after I've rebooted.

The module code has nothing to do with the excel file which I've tried
to open.

Does anyone how to clear this up? Thanks.

Matthew Kramer


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

how clear up this problem
 

Hi Matthew,

Open the problematic module and look for two identically named subs. If
found, rename one. Save Personal.xls.

for the last months, whenever I try to open up ...

Are you sure that your name isn't Job?


---
Regards,
Norman



"Matthew Kramer" wrote in message
...
For some reason, for the last months, whenever I try to open up an excel
file, the code for one of my vb modules in my personal folder comes up
all the time.

At the top, it says microsoft vb - personal.xls module14 (code). There
is an error message: compile error: ambiguous name detected. When I
click the x at the corner right top, the code screen clears. But then I
am asked whether I want to enable or disable the macro.

Finally, the excel file which I had originally intended to open appears.
But this problem of this mysterious module code always coming occurs all
the time, even after I've rebooted.

The module code has nothing to do with the excel file which I've tried
to open.

Does anyone how to clear this up? Thanks.

Matthew Kramer


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!