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.

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.