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

Just some thoughts ..

The sub: ProductionOrder could be one located within Personal.xls
rather than the file/book itself.

When you do an ALT+F8 on the original PC, does it appear in the Macro dialog
as: Personal.xls!ProductionOrder ? (rather than just: ProductionOrder)

If so, try copy the sub over from Personal.xls to the file itself in VBE's*
project explorer's window then save the file. Now the file will carry the sub.
*Press ALT+F11 to go to VBE, the project explorer window should be tiled on
the top left [titled: Project - VBAProject]. Press CTRL+R to make it visible
if necess.

To copy the sub, in VBE's project explorer's window, find & drag the module:
ProductionOrder from amongst those listed under Modules in VBAProject
(Personal.xls), then drop it into VBAProject (<your file.xls)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Raybs" wrote:
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

Slight clarification to line:
When you do an ALT+F8 on the original PC ..

Line reads clearer as:
In your file, when you do an ALT+F8 on the original PC ..

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---