Cant exit design mode b/c control 'TextBox1' cant be created

[Paradigm_Shift]

I have created a spreadsheet to track income and expense entries for my organization, and I have used ActiveX controls in Excel 2010 at the top of the sheet for data entry. For the user to enter the income/expense description, I have placed a TextBox.

The entire sheet works just fine with my VBA on my desktop and laptop. But when I had a friend test it on his laptop (w/ Excel 2007), when he tried to exit design mode, or do anything for that matter, he got the following error:

"Can't exit design mode because control 'TextBox1' can not be created."

I had him install MSCOMCT2.OCX to his system since I used the Date and Time Picker control. I also had him uncheck all MISSING: items that appear after selecting View>References in the VBE. These were issues I ran into when trying to view on my desktop after creating it on my laptop. Neither of these were the problem. Without being able to exit design mode, the VBA code can't be run.

The only code I have that governs TextBox1 is below:

Range("I15").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
ActiveCell.Value = Range("E1")
Range("E1") = ""

Cell E1 is the linked cell to TextBox1.

Why can't TextBox1 be created on his laptop and why does this cause design mode to not be able to be exited? My only guess is that it's either a bug with ActiveX controls in Excel 2007, or I have a service pack or something installed on my computers that he doesn't.

Let me know if you need any more information.
​