ExcelBanter - Can I remove a hyperlink without removing the color of the cell?

I'd copy the formatting (just the formatting) of your worksheet to another
blank sheet using Copy/Paste Special (Formattting). Then remove the
Hyperlinks using a *macro or **Paste Special (Add) method. And, Finally
Copy/Paste Special (Formatting) from the previously blank sheet back to the
original worksheet. So to answer your question, "I don't think so", but
there you could use this work around.

*Macro
Sub RemoveHyperlink()
ActiveSheet.Hyperlinks.Delete
End Sub

**Paste Special (Add) method (Non-Macro solution)
Select an empty cell (never used cell) and copy it (Ctrl+C) then select the
cells that you want to remove the hyperlinks from, then Edit, Paste Special,
Add.

--
Hope this Helps!
Camilo

Objective: To help one person each day!

Feedback is greatly appreciated! Please let me know if I've answered your
question or if my post was helpful to you?

"wendy" wrote:

Can I remove a hyperlink without removing the color of the cell? I would like
to do this to an entire spreadsheet that has all of the cells hilighted in
different colors.