Remove Hyperlinks
Press Alt-F11
Press Ctrl-G
Paste just this one line.
ActiveSheet.Hyperlinks.Delete
After you paste it, the cusor will move to the next blank line. Move
the cursor back up to the end of the line you pasted so that it's
flashing after "Delete". Then press enter. This should run the code
on the worksheet that you have active.
|