This is driving me crazy,
I am using Excel 2002, and I have a workbook that runs several macros.
There are several main macros that call other smaller macros periodically.

The problem I have is when I try to run one of the main macros it errors out
everytime it gets to the point where it wants to call one of the smaller
macros. It says the macro cannot be found.

All the macros are within the same workbook, and are in the same module.
None of them are private either.

Here's the weird part...
If I rename the workbook and also change the workbook name in every location
where one of the smaller macros is called it will work again. It works until
I close the workbook and open it up again, at that point it errors out again.
It will then work again if I change the workbook name again (this is an
endless process).

The question is: Is there something I need to change to allow these macros
to be found all the time without having to rename everything?

Thank you so much,
Brad

Hard to tell without seeing the code.

"bwilk77" wrote:

This is driving me crazy,
I am using Excel 2002, and I have a workbook that runs several macros.
There are several main macros that call other smaller macros periodically.

The problem I have is when I try to run one of the main macros it errors out
everytime it gets to the point where it wants to call one of the smaller
macros. It says the macro cannot be found.

All the macros are within the same workbook, and are in the same module.
None of them are private either.

Here's the weird part...
If I rename the workbook and also change the workbook name in every location
where one of the smaller macros is called it will work again. It works until
I close the workbook and open it up again, at that point it errors out again.
It will then work again if I change the workbook name again (this is an
endless process).

The question is: Is there something I need to change to allow these macros
to be found all the time without having to rename everything?

Thank you so much,
Brad

I actually just figured this out, I did a find and replace for the the name
of the workbook and accidentally left out the .xls at the end of the name.
Thanks for the response.

"JLGWhiz" wrote:

Hard to tell without seeing the code.

"bwilk77" wrote:

This is driving me crazy,
I am using Excel 2002, and I have a workbook that runs several macros.
There are several main macros that call other smaller macros periodically.

The problem I have is when I try to run one of the main macros it errors out
everytime it gets to the point where it wants to call one of the smaller
macros. It says the macro cannot be found.

All the macros are within the same workbook, and are in the same module.
None of them are private either.

Here's the weird part...
If I rename the workbook and also change the workbook name in every location
where one of the smaller macros is called it will work again. It works until
I close the workbook and open it up again, at that point it errors out again.
It will then work again if I change the workbook name again (this is an
endless process).

The question is: Is there something I need to change to allow these macros
to be found all the time without having to rename everything?

Thank you so much,
Brad