Hi,
I am trying to create a scoreboard to display on a monitor, hence, there will be two instances of excel open; Master file (list of scores), Display file (displays top 3 for each game).
My problem is that i can no longer use the below code to switch between books:
Workbooks("WorkbookName.xlsx").activate
Any ideas? (other than stretching one excel session over notebook and monitor)
Thanks AK
I am trying to create a scoreboard to display on a monitor, hence, there will be two instances of excel open; Master file (list of scores), Display file (displays top 3 for each game).
My problem is that i can no longer use the below code to switch between books:
Workbooks("WorkbookName.xlsx").activate
Any ideas? (other than stretching one excel session over notebook and monitor)
Thanks AK