Brian, Thank you for your help.
I copied my personal.xls with all the macros in it and then i tried to
go paste it over my colleauges "personal.xls" file but we could not
find his PERSONAL.XLS file on his machine. We did a search with hidden
files included but no luck. Then we also followd the exact same
directory path as mine to locate the file but could not find it. so we
could not paste my file (personal.xls) over his.

However, we double clicked on my "personal.xls" after pasting it in my
colleauges C drive, he was able to access all the macros. However, if
we don't click on the "personal.xls" after starting excel then those
macros are not available. Unlike on my machine, whenever I start excel
those macros are always available.

Can you please help so whenever my colleauge opens excel then the
macros are always available without him having to open the
"personal.xls" file that we pasted on his C drive?
Thank you very much for your help.
Regards.
IK