Sherees,
Since you didn't post the macro for inspection and help. I will take a shot
in the dark for you.
Look at the coding of your macro, if it refers to the workbook by name, then
eventhough you rename it, the macro is still looking for the original file.
The easy fix to this is:
The file with its new name on the machine that is going to use your macro,
Open the excel VB editor and check the macro code.
If it refers to file GWR.xls or whatever you named it originally, then just
change the reference to the new name and save.

hth

"Sherees" wrote:

I assigned macro to a button to print specified areas, this was properly
working in the computer in which i created this file. I gave the file name
GWR.xls while creating it. After the work is complete i moved it to a new
folder with a different file name and the same was carried to other computer.
Now when i clicked the button from other computer, the error message read
something like this"'file GWR does not exist,..and so on''. so i changed the
file name back to GWR, even then the buttons were not working. Macros is
enabled. Will the macros stop fucntioning if the name of the file is changed?
--
Life isa journey not a destination


"Dave Peterson" wrote:

My first guess is that the security setting in the recipient's pc is set to
disable macros.

Depending on the version of excel they're using, you can toggle it:

In xl2003 menus:
tools|macro|security|security level tab
set it for medium

The user will be asked if they want to enable macros when they open a file with
macros. If they answer yes, then your macros should work.

If they answer no, you'll have to teach them that they want to answer yes for
this workbook.

If this doesn't help, you'll have to explain what not working means.

Sherees wrote:

Merry X'mas
created an excel file with macros in it for printing. when i saved this file
on other computers, the buttons with macros assigned is not working. Is it
because that i changed the file name when i was saving it on other computer,
but when i changed it to the previous name then also the macros are not
working, please advice the solution. The file is properly working in the
computer from where i created the macros, even thoughthe file name is
changed. Macros were enabled in all the computers.

Thanks & rgds
--
Life isa journey not a destination

"Sherees" wrote:


--
Life isa journey not a destination

--

Dave Peterson
.