I have an Excel macro application run beautifully on a PC using Excel-97. I
cannot get it to run on other PC's (same vintage) in my office. I want to
upgrade all PC's and version of Excel being used, but I am reluctant to start
the upgrade process until I can get the macro working on more than one PC.
When I click on the macro icon I get the message "The macro ProductionOrder
cannot be found".

I can see that ProductionOrder is a subroutine within a Visual Basic macro,
but copying that file to my test PC does not overcome the problem. Does
anybody have any ideas?

Ray