I have an outlook macro that I use to extract data from outlook and place in an excel workbook. This macro is going to be used by 15 other areas across the country for my company. This is about 15 different people who will need to use it essentially. The userform is a drop down list where I have listed the acronyms for those 15 areas. The user selects their respective area, and the data is then pasted into a corresponding spreadsheet located on our sharepoint. There are 15 excel workbooks that correspond to each area. There will eventually be a master workbook that takes the data from each of these area workbooks and brings it into the master. The macro successfully works on my computer, but whe n I exported it and then sent it via email to a coworker in a different area to test, that is where problems arise. All the macros import successfully, including the userform.frm, but when trying to import the frx file, the error comes up that I am unable to do it. Additionally, a log file gets added that states: "Line 2: The Form or MDIForm name UserForm2 is already in use; cannot load this form." Through various google searches, I have found that I have to change the name in the frm file. I have doen this as shown below, but I still get the same error. I am usnsure of what exactly I have to do. I have changed the UserForm name as well in the macro where my selection choices and excel paths are located, but to no avail. Any help would be greatly appreciated. The userform code is below. My original UserForm name is UserForm2. I changed the names shown below to UserForm3, and that did not do it. Am I missing something? How can I share this with 15 different people?

Code:

I changed this code from UserForm2 to UserForm3 and I still get the frx error.
VERSION 5.00
Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} UserForm3
Caption = "UserForm3"
ClientHeight = 3180
ClientLeft = 45
ClientTop = 375
ClientWidth = 4710
OleObjectBlob = "UserForm3.frx":0000
StartUpPosition = 1 'CenterOwner
End
Attribute VB_Name = "UserForm3"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub SelectArea_Click()
lstNum = ComboBox1.ListIndex
Unload Me
End Sub
Private Sub UserForm_Initialize()
With ComboBox1
.AddItem "ALB"
.AddItem "Carolinas"
.AddItem "Charlotte"
.AddItem "CNY"
.AddItem "CTX"
.AddItem "Greensboro"
.AddItem "KC LIN"
.AddItem "KTY"
.AddItem "MID"
.AddItem "NEO"
.AddItem "New England"
.AddItem "NTX"
.AddItem "NYC"
.AddItem "Raleigh"
.AddItem "South Carolina"
.AddItem "STX"
.AddItem "SWO"
.AddItem "WIS"
.AddItem "WNY"
.AddItem "Zone 1, 2 ,3, 4"
.AddItem "Zone 5, 6"
.AddItem "Zone 7, 8"
.AddItem "Zone 9, 11"
.AddItem "Zone 10, 12"
End With
End Sub
Private Sub CancelButton_Click()
Unload Me
End
End Sub
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then
End
End If
End Sub