Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
group comment format on text
hi all
i would like to know if one of you can help me. i want to change the text of a comment . this has to be done for the whole sheet and in the defalt settings if possible thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
group comment format on text
Per Debra Dalgleish
Apr 1 2004, 10:16 pm You can't turn the feature off. You can substitute another word for your name, such as "Note". However, the comment will always start with the contents of the User Name box, and a colon, in bold text. You can use code to insert a comment formatted as desired, with no name. There's sample code he http://www.contextures.com/xlcomments03.html HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "wildlysa" wrote: hi all i would like to know if one of you can help me. i want to change the text of a comment . this has to be done for the whole sheet and in the defalt settings if possible thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading zeros in text format | Excel Discussion (Misc queries) | |||
Custom Number Format Text | Excel Discussion (Misc queries) | |||
How do I set Excel cell format to "Text" from VB.NET? | Excel Discussion (Misc queries) | |||
format cells having text | Excel Discussion (Misc queries) | |||
how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions |