Switching between workbooks

Hi
I have a parent workbook that has a dynamic name, so I used one word in the file name that was constant to set the workbook.

Next I am taking 2 tabs from this workbook and creating new workbooks from them. My problem is I cannot seem to flip back and forth between the parent and the new workbooks.

I get error message at the first step that says "runtime 1004 Application defined or object defined error"

I'm sure its a simple fix, but I've tried so many things, I can't get it!

Please Login or Register  to view this content.