Can you create links in one workbook to open up other workbooks? Is there a formula so when you click on a cell, it opens up the desired spreadsheet? If so, How?
Can you create links in one workbook to open up other workbooks? Is there a formula so when you click on a cell, it opens up the desired spreadsheet? If so, How?
Good afternoon mattcross55
...and welcome to the forum!!
No there isn't. A formula is passive and can do no more than return a value. However, you could use a macro to run through the LinkSources object and open each workbook it finds in there. Use the macro below to do this :Originally Posted by mattcross55
HTHPlease Login or Register to view this content.
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
If you create a hyperlink and hyperlink it to the file, when you click on it the second file will open. This works on any type of file PDF, DOC Etc.
Yes it will. we just have to figure out how...
If I have helped you, PLEASE click the * and add to my Rep.
Also, if the problem is SOLVED please mark it as so.
Thanks very much for that. Just tried it out and my boss got so exited he's told me to spend the rest of the day setting up hyperlinks. Thats got pay rise written all over it.
Nice one friend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks