Hi there,

I have a column which has lots of difference references to statements on a
different sheet and when click on it fires up user forms and stuff for them
to fill in which is all fine and dandy. Problem I'm having is I want to add
another one asking them whether the statement is correct if yes then it exits
the sub and if its no then it will take them to the workbook and the relevant
cell in order to let them edit the source.

This is an example of one of the links it is sat in E2:
='http://knet/sites/fapas/risk/InformationSecurity/IS
Documents/Plan/[Statement of Applicability.xls]Annex A and New SOA'!I195

How would I get it to read this as a link and then load it up to the
relevant cell?