For Macro - Specify Userform Workbook

Hi there,

I have several versions of a workbook I am working with, so I have made several copies of the same .XLS file and renamed them. They all have the same Userforms in them, and I have a button on my worksheets that runs a macro "UserForm1.Show"

It works, but it tries to open the UserForm1 from the original .XLS file instead of using the UserForm1 from the version of the .XLS file I already have open. How can I specify a path / force the macro to open the UserForm1 from my current open workbook without having to load the original?

Example: My first XLS is called EntryMaster, and one of my other versions is EntryVersionA. When I try to open my UserForm1 from EntryVersionA, it attempts to open the UserForm1 from EntryMaster instead...

I've tried something like this in the macro:

Excel.ActiveWorkbook.UserForm1.Show

but this is the wrong syntax for this. Anyone have any idea to stop this behaviour? Thanks!