Discussion Locked

Excel Hyperlink

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I can hyperlink and un-link individual cells in Excel w/o a problem. I have yet to figure out how to un-hyperlink an entire column or row simultaneously. Any suggestions?

3 replies

by dklippert

Write a short macro:

Sub NoHyperlinks()
Selection.Hyperlinks().Delete
End Sub

Select the area you want to deactivate, and run the macro.

This discussion is closed to new replies.