Ah, didn't know that.

So, that explains why it won't open the workbook properly when I have it closed. Does the same apply to activate worksheets in other workbooks? If it does, that would explain both of my problems.