Personal.xls vba projects

[Muttley]

Hi

I have code stored in my personal macro workbook that saves a file with a certain file name. Problem is it also copies across the macro that saves it to the new file. When I come to run the macro again, it does not execute from the personal macro workbook, but from the previously saved version.

I am using the 'Save as' method to create the original saved file (I thought of using 'SaveCopyAs' instead, but this does not allow you to set a password).

How can I prevent this from happening???

Thanks

 

[LoNeRaVeR]

Muttley:

Copy the sheets or just the data in the sheets from the workbook into a new workbook and then save the file. Regards,

LoNeRaVeR