title: How to create a macro that will open a userform from an Add-in without opening the workbook
body: <p>I developed a userform that queries the form's workbook for information. I want this userform to be available in other workbooks so users can lookup information in the form's workbook while working in their own workbooks. </p>
  
  <p>Originally I tried using this on opening the workbook:</p>
  
  <p><em>Application.visible = False<br>
  Userform.show vbmodeless</em></p>
  
  <p>However, this will hide all other workbooks in excel which will confuse the user.</p>
  
  <p>I then tried saving the userform workbook as an excel add-in and created a macro in the ribbon that will launch the form via the show vbmodeless function, but this pulls up the userform's workbook as well.</p>
  
  <p>I am new to VBA; is there anyway to pull this off where a user can be working in their workbook and pull up my userform without opening the userform's workbook. The userform does not interact nor need to interact at all with the individual's personal workbooks, just the workbook from which the form originates. I would prefer this to work from the ribbon, but if it is just from opening the userform workbook that is ok too. </p>
  
  <p>Thanks!</p>