Hi Michael

Copy the code in your personal.xls and use activesheet in your code
You can run the macro then in any worksheet that is active

If you need more help post back

--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message ups.com...
I have a simple subroutine that does a Find Replace on the first column
of a worksheet. I get workbooks e-mailed to me that I want to run this
subroutine on. Is there anyway to do this other than copy and paste
the code onto each new workbook? Thank you,
Michael