Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JAB
 
Posts: n/a
Default How to remove Hyperlink without changing cell format?

I have created a spreadsheet to use as a Master Form and many of the calls
are use as title boxes. Some of them will include Hyperlinks. At times I will
change or remove a Hyperlink, but when I do, that cells format changes. So,
my question is how do I prevent this from happening?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anne Troy
 
Posts: n/a
Default How to remove Hyperlink without changing cell format?

You may want to consider creating a new style (create a cell formatted to
look just like your hyperlinks, then hit Format--Style and choose Add, give
it a name) that looks the same as a cell with a hyperlink (which is an
automatic or predefined style) and apply it to the cell after you remove a
hyperlink.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"JAB" wrote in message
...
I have created a spreadsheet to use as a Master Form and many of the calls
are use as title boxes. Some of them will include Hyperlinks. At times I
will
change or remove a Hyperlink, but when I do, that cells format changes.
So,
my question is how do I prevent this from happening?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell format changing when when using search and replace. Excel Discussion (Misc queries) 0 January 6th 06 03:41 AM
Changing cell format - for example text to numeric sjrku Excel Discussion (Misc queries) 3 December 30th 05 11:40 PM
" / " Changing Decimal number format to Fraction on Protected Cell laudie Excel Worksheet Functions 0 November 15th 05 02:12 AM
Cond. Format & Absolute Cell Reference Question nastech Excel Discussion (Misc queries) 4 November 9th 05 06:02 PM
how do I format a cell reference to move as source changes KGray Excel Worksheet Functions 1 August 13th 05 01:41 AM


All times are GMT +1. The time now is 03:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"