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?

Thanks again Barnabel
I have looked in my Excel start up, but it is empty. I have tried now in a
test version to delete all my macros in VBA. When I check under Tools in VBA,
there are no macros what so ever. Then I go back to Excel and I click on the
ikon for macros on the fluent ribbon, and it shows me 9 macros (so here is
the name conflict, that you mentioned). The delete button is shadowed, but
not the edit button. If I try to Edit, it tells me, that the reference is
invalid.

I have worked on this workbook for many years. In a prior version (perhaps
the one before 2003), you could add macro-names to the buildt in menu, so
that you could call your own macros from the Excel menu. Is it possible, that
these names still hang somewhere in the system, and that these names are the
ones, that I can see in Excel allthough there are no macros in VBA?

"barnabel" wrote:

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?

Sorry at this point I have no further help. I've never tried puting macros
on the menu. I have excel 2000 & 2007 in the office and 2003 at home. I'll
look at this later today and see if I can figure out how it would cause
problems but I hoped somebody else would jump in with suggestions.

"Claus Højlund" wrote:

Thanks again Barnabel
I have looked in my Excel start up, but it is empty. I have tried now in a
test version to delete all my macros in VBA. When I check under Tools in VBA,
there are no macros what so ever. Then I go back to Excel and I click on the
ikon for macros on the fluent ribbon, and it shows me 9 macros (so here is
the name conflict, that you mentioned). The delete button is shadowed, but
not the edit button. If I try to Edit, it tells me, that the reference is
invalid.

I have worked on this workbook for many years. In a prior version (perhaps
the one before 2003), you could add macro-names to the buildt in menu, so
that you could call your own macros from the Excel menu. Is it possible, that
these names still hang somewhere in the system, and that these names are the
ones, that I can see in Excel allthough there are no macros in VBA?

"barnabel" wrote:

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?

Thanks for your help, barnabel
A new thing occured today. My students use my workbook, and they all have
Excel 2007, but som have XP and som have Vista. It's only on the Vista PC´s
that Excel makes the new "Modul1...." name. So perhaps it is all Vista´s
security, that makes the problems.
Anyway, I have renamed my macros in order to get out of the name-conflict.
It seems to work. For now I will have to live with the "old names in Excel,
not in VBA". My biggest concern right now is that it takes 45 sek. to print 2
pages with my macro, but only 6 without a macro. I'll start a new question
about this problem.

"barnabel" wrote:

Sorry at this point I have no further help. I've never tried puting macros
on the menu. I have excel 2000 & 2007 in the office and 2003 at home. I'll
look at this later today and see if I can figure out how it would cause
problems but I hoped somebody else would jump in with suggestions.

"Claus Højlund" wrote:

Thanks again Barnabel
I have looked in my Excel start up, but it is empty. I have tried now in a
test version to delete all my macros in VBA. When I check under Tools in VBA,
there are no macros what so ever. Then I go back to Excel and I click on the
ikon for macros on the fluent ribbon, and it shows me 9 macros (so here is
the name conflict, that you mentioned). The delete button is shadowed, but
not the edit button. If I try to Edit, it tells me, that the reference is
invalid.

I have worked on this workbook for many years. In a prior version (perhaps
the one before 2003), you could add macro-names to the buildt in menu, so
that you could call your own macros from the Excel menu. Is it possible, that
these names still hang somewhere in the system, and that these names are the
ones, that I can see in Excel allthough there are no macros in VBA?

"barnabel" wrote:

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?

To Barnabel and others with the same problem
My problem was "old macros in Excel but not in VBA". To solve the problem, I
have copied every sheet into a new Excel 2007 Workbook, and then copied all
the macro modules into the same workbooks VBE. In this "clean" workbook I now
have the same macros - no more no less - in Excel as I have in VBA. My best
guess is still, that either 2007 or Vista have discovered the old macro names
attached to the menu-system som versions back somewhere. But who knows? The
mane thing is that with a bit of copy and paste the problem has disappeared.
Thanks a lot Barnabel for your help.

"Claus Højlund" wrote:

Thanks for your help, barnabel
A new thing occured today. My students use my workbook, and they all have
Excel 2007, but som have XP and som have Vista. It's only on the Vista PC´s
that Excel makes the new "Modul1...." name. So perhaps it is all Vista´s
security, that makes the problems.
Anyway, I have renamed my macros in order to get out of the name-conflict.
It seems to work. For now I will have to live with the "old names in Excel,
not in VBA". My biggest concern right now is that it takes 45 sek. to print 2
pages with my macro, but only 6 without a macro. I'll start a new question
about this problem.

"barnabel" wrote:

Sorry at this point I have no further help. I've never tried puting macros
on the menu. I have excel 2000 & 2007 in the office and 2003 at home. I'll
look at this later today and see if I can figure out how it would cause
problems but I hoped somebody else would jump in with suggestions.

"Claus Højlund" wrote:

Thanks again Barnabel
I have looked in my Excel start up, but it is empty. I have tried now in a
test version to delete all my macros in VBA. When I check under Tools in VBA,
there are no macros what so ever. Then I go back to Excel and I click on the
ikon for macros on the fluent ribbon, and it shows me 9 macros (so here is
the name conflict, that you mentioned). The delete button is shadowed, but
not the edit button. If I try to Edit, it tells me, that the reference is
invalid.

I have worked on this workbook for many years. In a prior version (perhaps
the one before 2003), you could add macro-names to the buildt in menu, so
that you could call your own macros from the Excel menu. Is it possible, that
these names still hang somewhere in the system, and that these names are the
ones, that I can see in Excel allthough there are no macros in VBA?

"barnabel" wrote:

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?