Thread: Hyperlink
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Hyperlink

Enter this tiny macro:

sub hypergone()
Selection.Hyperlinks.Delete
end sub

Select the area of the worksheet and run the macro.
--
Gary's Student


"Ramo" wrote:

User has a spreadsheet that no matter the cell you click, it will open a new
email.
I did a right click on a cell and clikc on "remove Hyperlink", that will
work for that cell, Can I remove the hyperlink for the whole expreadsheet?
Thank you
ramo