drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 540
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance!
If I want to remove a Hyperlinks for the activecell I can use:
But how can I delete the just Hyperlinks for the Activecell without losing the formatting ?
Deletes averything but the content
If I want to remove a Hyperlinks for the activecell I can use:
VBA Code:
ActiveCell.Hyperlinks.Delete
But how can I delete the just Hyperlinks for the Activecell without losing the formatting ?
VBA Code:
ActiveCell.Hyperlinks.Delete