software

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 quot;remove Hyperlinkquot;, that will
work for that cell, Can I remove the hyperlink for the whole expreadsheet?
Thank you
ramo

Enter this tiny macro:

sub hypergone()
Selection.Hyperlinks.Delete
end sub

Select the area of the worksheet and run the macro.
--
Gary's Studentquot;Ramoquot; wrote:

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

Gary''s Student

I worked great
thank you
ramo

quot;Gary''s Studentquot; wrote:

gt; Enter this tiny macro:
gt;
gt; sub hypergone()
gt; Selection.Hyperlinks.Delete
gt; end sub
gt;
gt; Select the area of the worksheet and run the macro.
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Ramoquot; wrote:
gt;
gt; gt; User has a spreadsheet that no matter the cell you click, it will open a new
gt; gt; email.
gt; gt; I did a right click on a cell and clikc on quot;remove Hyperlinkquot;, that will
gt; gt; work for that cell, Can I remove the hyperlink for the whole expreadsheet?
gt; gt; Thank you
gt; gt; ramo