<div>
Perfect<br />
<br />
Thanks
</div>


<div>
Follow up question<br />
<br />
<a href="https://www.experts-exchange.com/questions/28935216/Adding-history-to-link-follower.html" rel="ugc">https://www.experts-exchange.com/questions/28935216/Adding-history-to-link-follower.html</a>
</div>


Follow up question

https://www.experts-exchange.com/questions/28935216/Adding-history-to-link-follower.html [https://www.experts-exchange.com/questions/28935216/Adding-history-to-link-follower.html]

<div>
<div class="content wysiwyg-content">
Various cells have links to other worksheets, other workbooks in this form<br />
<br />
='D:\SMBP\Engineer Estimate (Final Draft &nbsp;19.03.16)\Chapter No. 1\[Const. of New Barrel.xls]Abstact of Cost'!$C$8<br />
<br />
='1_COST (Barrel)'!F80<br />
<br />
I would like to have a macro which opens or activates the file or worksheet and the cell which is referred to.<br />
<br />
It would be good to have another macro which would let me go back to the cell from where the file was opened.
</div>
</div>


Various cells have links to other worksheets, other workbooks in this form

='D:\SMBP\Engineer Estimate (Final Draft  19.03.16)\Chapter No. 1\[Const. of New Barrel.xls]Abstact of Cost'!$C$8

='1_COST (Barrel)'!F80

I would like to have a macro which opens or activates the file or worksheet and the cell which is referred to.

It would be good to have another macro which would let me go back to the cell from where the file was opened.

Macro to follow links

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.