You would do better to post this in the Office Software forum, which covers Excel and Excel macros.
If you do re-post, can you identify where your macros are. If your workbook is say Form1.xls, is the macro in the VBAProject(Form1.xls) Sheet1 object. or a standard Module such as Module1 in VBAProject(Form1.xls).
If your macros are attached to the workbook itself, you should be able to put them in a standard module attached to PERSONAL.XLS. It will then only be attached to your PC / your copy of Excel.
Also are your macros run from buttons embedded in the worksheets. If so, using Toolbar buttons would separate the functions from the distributed workbooks and keep them on your PC.