Here's another idea. It sounds like you have two instances of the same
workbook open and you what two be able to compare two different tabs without
having to switch back and forth. Using what I mentioned before about
stretching the window across both monitors, click on Window | New Window.
Now you have two views of the same workbook and you can change tabs
separately. It will also let you reference the other sheet the way you
mentioned with the exception of an extra click due to having to click ones
to activate the other view.
If you are using two different workbooks, it should function in the same
way.

HTH,
Paul

--

wrote in message
...
No, im not comparing changes between two of the same files (which is
what your addin seems to do) I am looking at two sepearte spreadsheets
and referencing cells between them. In fact if it is able to be done
( I hightly doubt it) a feature that would be awesome is to have the
same exact workbook open on each monitor. And then be on different
sheets in the workbook so that you can reference a cell from a
previous sheet without having to switch tabs.

Make sense?