Hi Will A

The problem here isn't a problem with the code but a problem with the
location of the code.

If that's the case your best bet is probably to open the "old" personal
workbook and export the macro (right click on the module in the VBE and
select Export File). then open the "new" personal workbook and import
the macro back in, and save the workbook.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=483167