The short answer is no. Your best bet is to save the macro in a template and distribute that template as an add-in. When it needs changing you can save the updated template in a self extracting zip file and the users can use it to update their copies.