Userform won't open with worksheet. Causing error and force close.

[Note: I made a mistake in the title of this thread it should say workbook not worksheet] So I have a user form called "User_Controls" and another macro that opens and locates it. When I try to call this in the Sub Workbook_Open it force closes excel. The weird thing is it only does it if I have already enabled macros for the workbook. When I change the workbook name so it prompts me to enable macros again and click "enable content" it works just fine. Any idea what could be going on here and how I could fix it? BTW I have also tried using Sub Workbook_Activate as well to launch the user form and got the same result. My code is below. Thanks for the help.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

FYI I also posted this question on the MrExcel forums here:
http://www.mrexcel.com/forum/excel-q...ml#post3432897