Open your file with macro code, Save As - choose type "Add-on (.xlam)", Open new excel file, then Developer tab - Add-Ins. Choose just saved file (check it).
Now this macro code will be avaliable in all excel files.
This can solve our issue when you create new file and close original. Your code still will be avaliable in this newly created file.