Didn't think i had explained this very well so here goes -

Have a workbook  called Master.xls which contains a form  with a
customers information  on it (and various other worksheets feeding
from the form).

Different individuals in the office enter information into the form
and then save a copy of the workbook under whatever name they choose
and they do this for several customers under whatever names  they
choose.

Now I am not allowed to actally make any changes to the form so what
i have done is stuck macros  on a seperate workbook which will be
open alongside the saved form. My companion workbook has command
buttons that allow you to rearrange information on the form and copy
information from the form to the companion workbook

Everything was alright until i realised that the code might be used
on saved forms with different names and now i'm lost. I'm trying to
make it as easy to use as possible. It will be used on one workbook
at a time with basically a random name.

Is there a way they can pick the workbook to be used from list of
their saved workbooks  and this value passed to my macros. Sounds a
tad out of my skill range at the moment.