Problem with excel macros

I need access to Excel macros from different files.
It disappears even in one after some time. At first it works, and then in the same file is no longer

modules themselves change

It is because you must have saved the macro in " thisworkbook " if thats not the case if you have saved it in “personal workbook”.Still if the macro is not present sometimes
then you can try opening the the personal.xlsb( " C:\Users\ “user name” \AppData\Roaming\Microsoft\Excel\XLStart") first before executing the macros.
which will incase load all the macros.