If you're running the macro against the activesheet, then it doesn't matter
where that file is located--as long as the file is open and the correct
worksheet is active.

wayne wrote:

On 07/16/2009 07:27 PM, Dave Peterson wrote:
If I had the same layout in several worksheets (even in several workbooks), I
wouldn't duplicate the code in each of the workbooks.

I'd create a single workbook (or addin) that contained all the code. Then each
time I needed any of the macros, I'd run the code from that workbook with the
macros.

But the suggestions for doing validity checks still stands.


Thank you for all of your help. The workbooks are not in the same
location though so using the vba from one workbook is not an option.

Regards,

--
Wayne
glenmeadows.us
A democracy is nothing more than mob rule, where fifty-one percent of
the people may take away the rights of the other forty-nine. [Thomas
Jefferson]

--

Dave Peterson