Check this thread: https://forum.solidworks.com/message/824308#comment-824308
My recommendation would be to switch to add-ins or stand-alone applications vs VSTA macros as I found them to be unreliable. Check this article: Getting Started
Agreed with @Artem as it's also an issue with distributing your macro too
Thanks for your response. Would you recommend any books or tutorials for learning/understanding SolidWorks Stand Alones and Add-ins.
I am aware of AngelSix YouTube Channel.
Thanks in advance