Need Help with Macro Enabled Excel File to Save and Edit on other Pc too.

[Naya_Soch]

I had this woksheet i created using Add ins or Macro to calculate Some Calculations and I need to share this worksheets with others too, so that they don't need to create their own( it'll definitely take a whole week definitely) and just input the no and olah!!! Required Amount will be displayed. Magic!!!. But the Real Problem is that when i acess my worksheet from their pc after i copy them to my pendrive as Macro enabled workbook and open it and when i edit it then output goes like NAME??, and if i Double click it it shows" ='I:\Documents and Settings\Uermne\My Documents\Sajan.Nepali.Functions.V4.xlam'!AD2BS(D5) and which makes no sense.
So what miracle can happen so that i could include both macros and worksheet and acess file from other pc too and instead of making whole Formulas, just only could edit and get the outcome. If anyone is out there, i Would really Appreciate your Help.