binitjoshi
New Member
- Joined
- Dec 2, 2016
- Messages
- 1
Hi,
I am trying to create a macro that stores all the active workbooks (also save the last active and currently active workbooks) and also hold the currently active and previously active sheets for each workbooks so that I can use Application.OnKey to move between current and last workbook and also move between the last and current sheet in each workbook.
I was trying nested collection, but I am very new to this and could not do it.
Can anyone help me out please?
I am trying to create a macro that stores all the active workbooks (also save the last active and currently active workbooks) and also hold the currently active and previously active sheets for each workbooks so that I can use Application.OnKey to move between current and last workbook and also move between the last and current sheet in each workbook.
I was trying nested collection, but I am very new to this and could not do it.
Can anyone help me out please?