Hyperlink

[Ramo]

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]

Enter this tiny macro:

sub hypergone()
Selection.Hyperlinks.Delete
end sub

Select the area of the worksheet and run the macro.

 

[Ramo]

Gary''s Student

I worked great
thank you
ramo

Enter this tiny macro:

sub hypergone()
Selection.Hyperlinks.Delete
end sub

Select the area of the worksheet and run the macro.