Macro problem where workbook name is saved in another name and macro reference changes

[BobR]

Hello, Excel 2003 and 2007. I have numerous macros in my spreadsheet and
have been forced to change the name of the worksheet and workbook over the
past few weeks. Today I sent the worksheet out to others in my group and
some of the macros refer directly to the pages within the workbook, but some
of the macro's show the entire path (which doesn't esist anymore) and won't
work.
Does anyone have any ideas or know of a way to keep the macros references
directly to the existing workbook, no matter where it's located.
Thanks
Bob R

 

[BobR]

Ok, since I didn't do a good enough job in explaining my problem, let me go
one more time.
Is there a way, when using named cells or ranges in an Excel worksheet to
ensure the reference stays with that worksheet and doesn't change?
My example would be: First named range shows as Utility:!$R$232
subsequent ones show up as C:\Documents and
Settings\rjr\desktop\Excelworksheet]!Utility!$R$232.

and in my case the path, stays this way until I open and save it in another
program on another computer and then I get the error's. They will change,
depending on the workbook that I have open and then won't compute when the
macro's are activated.

Any help, questions or ideas are welcomed.
Thanks
BOB



C:\Documents and Settings\RJR\