IT-Academy

Odstran hyperlinky SUB

Nov 29th, 2017
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub odstranHypertext()
  2.  
  3.     Dim hyp As Hyperlink
  4.  
  5.     For Each hyp In ActiveSheet.Hyperlinks
  6.         hyp.Delete
  7.     Next
  8.  
  9. End Sub
  10.  
  11. Sub odstranHypertextsTextom()
  12.  
  13.     Dim hyp As Hyperlink
  14.  
  15.     For Each hyp In ActiveSheet.Hyperlinks
  16.         hyp.Range.Delete
  17.     Next
  18.  
  19. End Sub
Advertisement
Add Comment
Please, Sign In to add comment