Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cell format changing when when using search and replace. | Excel Discussion (Misc queries) | |||
Changing cell format - for example text to numeric | Excel Discussion (Misc queries) | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions |