IT-Academy

Odstran hyperlinky SUB

Nov 29th, 2017
285
0
Never
1
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
Comments
  • User was banned
Add Comment
Please, Sign In to add comment