Quote Originally Posted by Excel Fox View Post
In addition, if the workbooks are in the same instance, then try using Workbooks().Activate instead of Windows().Activate.
I already tried using Workbooks versus Windows and there was no difference, however the instance idea is interesting. How do I open 2 workbooks in separate instances versus the same instance. How will I know which mode I am in?