View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jasontferrell jasontferrell is offline
external usenet poster
 
Posts: 56
Default 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.