Macro works in step through but not when run

Hi everyone,
I have this macro that suddenly stopped working. I cant figure out why, I can post the code but not a workbook since its got protected info... but It runs until it opens the new workbook, and then it stops. Doesnt ask me for company name etc anymore, this was working this morning... very frustrating.
Anyways if anyone can help me out i'd appreciate it as this makes my day a lot easier when automated.

Please Login or Register  to view this content.

Through more research turns out that this is a bug in excel. Started because i Added the shortcut to my macro Ctrl+SHIFT+U.

According to http://www.excelbanter.com/showthread.php?t=172200
When you have a shortcut with shift it messes up when opening new workbooks.