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

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

Gary''s Student

I worked great
thank you
ramo

"Gary''s Student" wrote:

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