G
Guest
I need to toggle between two different open workbooks (these two would be the
only open visible workbooks at the time). The problem is that I don't always
know what the name of the workbooks will be. Could someone please help with
some code that would take the current active workbook, designate that
workbook as WB1, and then designate the other open workbook as WB2. In the
end, I want to be able to switch back and forth through the two as follows:
WB1.Activate
WB2.Activate
Thanks.
only open visible workbooks at the time). The problem is that I don't always
know what the name of the workbooks will be. Could someone please help with
some code that would take the current active workbook, designate that
workbook as WB1, and then designate the other open workbook as WB2. In the
end, I want to be able to switch back and forth through the two as follows:
WB1.Activate
WB2.Activate
Thanks.