Can someone suggest to me how to write a conditional statement that looks to find out if there are multiple windows open for a given workbook. i.e., If (more than one window for a workbook is open), Then (activate [this sheet] on Copy 1).
I can write the code to deal with 2 copies of a workbook being open. Problem is, I don't know that that's always going to be the case. So I need to test for that, do one thing if more than one copy is open, and do something else if only one copy is open.
Thanks.
Peg