Okay, thanks. Here goes:

There will be a daily workbook that I would like to add validation to
by code. However, the workbook will be reproduced everyday so I wil
not be able to store the validation code (that I've already created) i
it. Therefore, I have created another workbook to contain the code an
the values I would like to use for validation.
Now, I don't want to create a menu item to run the code but want to ru
the code from the values/code book. However, because the 'daily' boo
will have a very different name each day I'm finding it hard to pas
it's name to a variable in order to select/activate the 'daily
workbook and run the code? I thought that there might be a way to ru
the code from the values/code book with some kind of parameter tha
will prompt the user to select the 'daily' book; ideally by selectin
from the taskbar or, perhaps, by selecting from a drop-down list o
open workbooks?

Hope this makes more sense?

Many thanks,

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=27331