Problem with excel macros

Help
, ,
1

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

2

Hi
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.