On my list over marcros I have "UdskrivStatus" and "Modul1.UdskrivStatus".
The first name does not have a macro, does not work and can't be deleted.
Originally this was the macro I made, but now only the "Modul1.UdskrivStatus"
works. But it works extremely slow. What to do? Originally the macro was made
i a 2003, but are now in a 2007 Excel xlsm. I haven't made the name
"Modul1.UdskrivStatus", so it seems to be a name made by Excel?

Excel prepended the "Modul1" to eliminate a naming conflict.

Select the macro you want eliminated and select edit. This will take you to
the module that actually has that macro in it. Select the text for the macro
and delete it. Make sure that the macro you want to keep still works before
saving anything.

Peter Richardson

"Claus Højlund" wrote:

On my list over marcros I have "UdskrivStatus" and "Modul1.UdskrivStatus".
The first name does not have a macro, does not work and can't be deleted.
Originally this was the macro I made, but now only the "Modul1.UdskrivStatus"
works. But it works extremely slow. What to do? Originally the macro was made
i a 2003, but are now in a 2007 Excel xlsm. I haven't made the name
"Modul1.UdskrivStatus", so it seems to be a name made by Excel?

Thans Barnabel for your interest.
When I want to edit the macro, I get the message, that the reference is
invalid, so I can't go there, and I can't delete it
mvh Claus

"barnabel" wrote:

Excel prepended the "Modul1" to eliminate a naming conflict.

Select the macro you want eliminated and select edit. This will take you to
the module that actually has that macro in it. Select the text for the macro
and delete it. Make sure that the macro you want to keep still works before
saving anything.

Peter Richardson

"Claus Højlund" wrote:

On my list over marcros I have "UdskrivStatus" and "Modul1.UdskrivStatus".
The first name does not have a macro, does not work and can't be deleted.
Originally this was the macro I made, but now only the "Modul1.UdskrivStatus"
works. But it works extremely slow. What to do? Originally the macro was made
i a 2003, but are now in a 2007 Excel xlsm. I haven't made the name
"Modul1.UdskrivStatus", so it seems to be a name made by Excel?

Hmmm..
Do you have anything checked under the tools-references that might be an
add-in that the function is residing in?

"Claus Højlund" wrote:

Thans Barnabel for your interest.
When I want to edit the macro, I get the message, that the reference is
invalid, so I can't go there, and I can't delete it
mvh Claus

"barnabel" wrote:

Excel prepended the "Modul1" to eliminate a naming conflict.

Select the macro you want eliminated and select edit. This will take you to
the module that actually has that macro in it. Select the text for the macro
and delete it. Make sure that the macro you want to keep still works before
saving anything.

Peter Richardson

"Claus Højlund" wrote:

On my list over marcros I have "UdskrivStatus" and "Modul1.UdskrivStatus".
The first name does not have a macro, does not work and can't be deleted.
Originally this was the macro I made, but now only the "Modul1.UdskrivStatus"
works. But it works extremely slow. What to do? Originally the macro was made
i a 2003, but are now in a 2007 Excel xlsm. I haven't made the name
"Modul1.UdskrivStatus", so it seems to be a name made by Excel?

Thanks Barnabel
This is strange. I don't have any add-ins, but if I look on my macros under
Tools in Visual Basic, I do not have any "Modul1..." macros, but only the
original Macros, and they are referenced correct to the VBA code in my modul
1. But when I go to Excel to look on my list of macros, I also have the
"Modul1..." macros, but the original macros doesn't work. Something is
happening between Visual Basic and the Excel window. Perhaps som old names
are hidden in Excel somewhere?

"barnabel" wrote:

Hmmm..
Do you have anything checked under the tools-references that might be an
add-in that the function is residing in?

"Claus Højlund" wrote:

Thans Barnabel for your interest.
When I want to edit the macro, I get the message, that the reference is
invalid, so I can't go there, and I can't delete it
mvh Claus

"barnabel" wrote:

Excel prepended the "Modul1" to eliminate a naming conflict.

Select the macro you want eliminated and select edit. This will take you to
the module that actually has that macro in it. Select the text for the macro
and delete it. Make sure that the macro you want to keep still works before
saving anything.

Peter Richardson

"Claus Højlund" wrote:

On my list over marcros I have "UdskrivStatus" and "Modul1.UdskrivStatus".
The first name does not have a macro, does not work and can't be deleted.
Originally this was the macro I made, but now only the "Modul1.UdskrivStatus"
works. But it works extremely slow. What to do? Originally the macro was made
i a 2003, but are now in a 2007 Excel xlsm. I haven't made the name
"Modul1.UdskrivStatus", so it seems to be a name made by Excel?

I am assuming that you looked at the project explorer and looked under each
thing in the project tree. Is it possible that you saved something in the
Excel start up folder that is being opened also?

"Claus Højlund" wrote:

Thanks Barnabel
This is strange. I don't have any add-ins, but if I look on my macros under
Tools in Visual Basic, I do not have any "Modul1..." macros, but only the
original Macros, and they are referenced correct to the VBA code in my modul
1. But when I go to Excel to look on my list of macros, I also have the
"Modul1..." macros, but the original macros doesn't work. Something is
happening between Visual Basic and the Excel window. Perhaps som old names
are hidden in Excel somewhere?

"barnabel" wrote:

Hmmm..
Do you have anything checked under the tools-references that might be an
add-in that the function is residing in?

"Claus Højlund" wrote:

Thans Barnabel for your interest.
When I want to edit the macro, I get the message, that the reference is
invalid, so I can't go there, and I can't delete it
mvh Claus

"barnabel" wrote:

Excel prepended the "Modul1" to eliminate a naming conflict.

Select the macro you want eliminated and select edit. This will take you to
the module that actually has that macro in it. Select the text for the macro
and delete it. Make sure that the macro you want to keep still works before
saving anything.

Peter Richardson

"Claus Højlund" wrote:

On my list over marcros I have "UdskrivStatus" and "Modul1.UdskrivStatus".
The first name does not have a macro, does not work and can't be deleted.
Originally this was the macro I made, but now only the "Modul1.UdskrivStatus"
works. But it works extremely slow. What to do? Originally the macro was made
i a 2003, but are now in a 2007 Excel xlsm. I haven't made the name
"Modul1.UdskrivStatus", so it seems to be a name made by Excel?