check you location of personel book.. you must be having two books i
different folders.

better way is to save your workbook as addins and then browse an
select the addin ..

other way is to give reference to your workbook from vba.. so th
workbook where you want to use your macros..this prevents every time
workbook to be open

--
Message posted from http://www.ExcelForum.com