How do I make a Shared Macro file portable?

I recently figured out how to put all my macro coding into one shared xlsm file. It works great; but only if you're connected to the server where that shared file lives.

If I want to send my spreadsheet to someone, and they don't have access to my share, they can't use the code (unless I send them the macro file and they know how update the links).

I'm trying to automate that by using "ThisWorkbook". It sort of works, but I don't want the "Edit links / Continue" message if the shared file doesn't exist.

I redirect the link buttons on the fly, each time the data sheet loads (there are only 6).

I'll use that for now, unless one of you GENIUSES posts a simpler answer.

Here is what I have so far (please don't laugh too much):

Please Login or Register  to view this content.