Distributable macro with userform stored on network drive

  • Good evening,
    I am creating a macro that allows the user to select sheets in a workbook via a userform activated with a custom ribbon tab. Locally I can make everything work. The issue I am having is distributing it, I was told to make the installation and use as simple as possible. I have tried to save as an add-in and programatically adding it. The add-in can't call the userform. I have tried saving as a personal workbook. The best solution I can find is to save the add-in on a remote server and loading it on workbook open. No matter how I go about it I cant get the custom tab to access the userform. I have attached the most complete version I have. Any help anyone could provide would be greatly appreciated. [ATTACH]n1212963[/ATTACH]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!