maokwen/remove-hyperlink-from-pictures.vb

Created February 27, 2020 17:20

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/maokwen/1d6c4922cfc83dabd405b89237fab77b.js"></script>
Save maokwen/1d6c4922cfc83dabd405b89237fab77b to your computer and use it in GitHub Desktop.

Download ZIP

Remove hyperlink from pictures

Raw

remove-hyperlink-from-pictures.vb

-Sub hyper()
-  Dim shp As Shape
-  For Each shp In ActiveSheet.Shapes
-    If shp.Hyperlink.Address <> "" Then shp.Hyperlink.Delete
-  Next shp
-End Sub

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment