I run a short bit of code upon opening my workbook. I have a button that runs more code. The first bit of code runs just fine, copying three worksheets from another workbook to this one. When I hit the button to run my other Macro, I get an Automation error and it crashes out, UNLESS I have the VB window open, in which case it works just fine.
I can run this all day long, but if I just open and run from the button or the Macro Dialog box, no dice.
Below is the Code that is run upon opening. Am I doing something wrong here? How can I fix this?