dcompagnone
Board Regular
- Joined
- Dec 14, 2007
- Messages
- 119
Hi,
Anyone help me with a small piece of code that will allow me to add a 'retur to last active sheet' type functionality to excel?
For example:
I have sheets 1 - 3 that contains all my data. from each of those, there is a link to a document on sheet 4 which you can populte, print and email. What I want to be able to do is then have a button that allows the user to go back to the sheet they came from rather than having to search through tabs for it.
This is a simplified version of my doc. I actually have nearly 100 sheets of data all linking to my 'printable/emailable' sheet.
Help appreciated.
Dom
Anyone help me with a small piece of code that will allow me to add a 'retur to last active sheet' type functionality to excel?
For example:
I have sheets 1 - 3 that contains all my data. from each of those, there is a link to a document on sheet 4 which you can populte, print and email. What I want to be able to do is then have a button that allows the user to go back to the sheet they came from rather than having to search through tabs for it.
This is a simplified version of my doc. I actually have nearly 100 sheets of data all linking to my 'printable/emailable' sheet.
Help appreciated.
Dom