Forum Discussion
alanmccarthy
Jul 22, 2020Copper Contributor
How to stop users adding links to other workbooks
Hi, We use Excel for preparing budget files. These files then get collated in MS Power BI for group wide analysis. One issue we have is that users can sometimes paste links from spreadsheets on the...
alanmccarthy
Jul 22, 2020Copper Contributor
NikolinoDE , the issue isn't hyperlinks as such, its cells pointing at external workbooks. So cells with values like the below
='[Desktop Budget File]Project Budget'!$I$23
or
=C://users/userA/desktop/'[Desktop Budget File]Project Budget'!$I$23
NikolinoDE
Jul 22, 2020Gold Contributor
im not sure but if you make a modul,
insert this code.
Option Explicit
Sub DeleteHyperlinks()
Worksheets("Text").Hyperlinks.Delete
End Sub
Please see this link too, maybe helps:
https://support.microsoft.com/en-gb/office/break-a-link-to-an-external-reference-in-excel-f1ca8b08-4f24-4af6-92e5-f4fdb1442748?ui=en-us&rs=en-gb&ad=gb
insert this code.
Option Explicit
Sub DeleteHyperlinks()
Worksheets("Text").Hyperlinks.Delete
End Sub
Please see this link too, maybe helps:
https://support.microsoft.com/en-gb/office/break-a-link-to-an-external-reference-in-excel-f1ca8b08-4f24-4af6-92e5-f4fdb1442748?ui=en-us&rs=en-gb&ad=gb