Hey guys,
I'm looking to format a large range of cells (A7:CZ200) so that the font is no longer formatted to blue when a user types in it. The issue is that the majority of cells are hyperlinks. Is there a way for me ignore font.color clearing the non-hyperlink cells? I've never worked with this kind of issue before, but the users would like hyperlinks to remain blue, and not hyperlinks to remain black.
I figured VBA would be the best bet.
Thanks for your thoughts,
Red
Edit: Just saw the part about the user typing in a value.
Please Login or Register to view this content.
The above code will evaluate all the cells in the range and change to black the non hyperlinks. To change a non-hyperlink to black as soon as the user types it in, use this:
Please Login or Register to view this content.
Last edited by walruseggman; 05-14-2015 at 11:54 AM.
Thanks a lot!
Just the kind of stuff I need.
Man this forum rocks.
rep'd
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks