![]() |
|
#5
|
|||
|
|||
|
Hi Paul,
The option you mentiond about using the hyperlink function i.s.o. a direct hyperlink looks very promising. I ran a quick test and it looks like it is working the way I want it. With the hyperlink function, file3 is opened and becomes the activated window while file1 stays in the background. file2 is not needed this way and that would be perfect. I need to test it in the actual file where we want the link but since I don't have rights to modify this file myself, this has to wait till friday when my colleague is back. I'l let you know what the outcome will be. So far I want to thank you for your time to help me. Best regards, Gerard |
| Tags |
| activate, unhide, workbook |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
#REF! error when opening a workbook that contain a refference to another workbook
|
tanababa | Excel | 2 | 06-07-2012 03:11 PM |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
| Unhiding a column | Maureen | Excel | 3 | 09-16-2011 08:57 AM |
macro to transfer data from one workbook to another workbook
|
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Select a range in one one workbook while working in other workbook
|
Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |